4th Week in 363 Database Management

 Briefly summarize 5 things what you have learned in the course so far.  

  1. Database Design Principles: I have learned how relational databases are structured and designed. How data is organized into tables that have columns and the relationships between those tables.

  2. Key Types : I learned about different types of keys used in databases, such as primary keys, composite keys, and foreign keys. 

  3. Joining Tables: I learned how to perform different types of joins like natural join, left join and right join to combine data from different tables.

  4. Using SQL Workbench: I have become familiar with SQL Workbench, and using SQL commands. This has helped me practice writing queries.

  5.  ER Diagrams: I learned about ER diagrams. ER diagrams are like a flowchart that helps use see how the entities are related. 

At least 3 questions you still have about databases.

  1. Joining Tables: I still have some difficulty understanding of different joins, like the left joins and right joins. I would get confused what data values would be null when using them. 

  2. One to Many Relationships: I had a hard time to fully understand one to many relationships, one to one relationships. 

  3. 3NF: I have studied the 3NF normal form, I still have trouble with remembering the conditions.

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