8th Week in 363 Database Management Final Week

 Wow, it's the last week. I am Miami at the 2024 first ever Robinhood Summit while I finish the class what a great way to end it. I can believe time passed so fast. Reflecting on everything I learn in class I can say three of the most important things are how relational databases work, their requirements to keep data integrity consistent, and commination within a team is very important. 

Relational databases are made of tables, and each table is made up of columns that define specific data types representing different values. Each table has a primary key, which uniquely identifies each record. In addition, relational databases have foreign keys that establish relationships between different tables.

Data integrity is maintained through the ACID properties. 

A is for atomicity which ensures that transactions are committed fully or not at all.

C is for consistency which keeps data consistent and valid.

I is for isolation which keeps transactions from updating the same record with the use of locks.  

D is for durability ensures that committed transactions persistent even if there is a failure.

Communication in a team is important because if everyone is not clear on who is doing what, it can end up wasting time. Regular check ins help avoid this. In addition, a follow up email detailing what everyone's roles can help making it clear.

Comments

Post a Comment

Popular posts from this blog

CST438 Software Engineering: Week 8 (Final week)

 One of the most important things I learned is that software engineering is about much more than just writing code. While coding is a big part, there's a strong emphasis on documentation, understanding client needs, and getting continuous feedback. It’s about designing systems so others can easily improve them and applying principles like "low coupling and high cohesion" to keep things modular and maintainable.      Another key lesson was understanding the entire development process from end to end. This was the first time I worked with both the front end and back end together, fully grasping the HTTP protocol (including how methods like POST work), how JSON is used, and how the front end communicates with the back end. Seeing how everything fits from database interactions to deploying the app online—gave me a fascinating glimpse into the full workflow and a lot of practical experience.      Another important lesson was learning how to work as part of ...
Read more

CST438 Software Engineering: Week 1

What did you expect a course in Software Engineering would cover? I expected it to cover how to build applications from the ground up and the design behind application development. I thought we would look at other things we’ve been learning in this program, like database management, front end development, and back end work, and then put it all together into one complete project. After completing week 1, how has your opinion changed? Well, I never really thought much about keeping an application’s design maintainable for future improvements or changes. There is a lot more that goes into software engineering than just simple programming. It is  about planning ahead, documenting your work, checking for errors, and testing properly to avoid issues later. I’ve also realized software engineering looks at the big picture it is not just about coding and design but about how software impacts people and how teams work together to build it. Developers need to stay motivated, think critical...
Read more

CST370 Week 5

Hello everyone,  This week we studied binary‑tree traversals preorder, inorder, and postorder but I kept mixing them up. I finally got it when I attended TA office hours, and it clicked. Walking through Quick Sort step by step helped me see how the Decrease and Conquer approach works by breaking problems into smaller chunks. Then we looked at Kahn’s algorithm, and watching it remove nodes with no incoming edges reminded me of picking a pivot in Quick Sort. Seeing these patterns repeat helped me realize that many algorithms work by simplifying things piece by piece. 
Read more