CST 363 - Week 4

 5 things I’ve learned so far:

1. I’ve learned how to break down large, messy data into normalized tables using 1NF, 2NF, and 3NF to reduce redundancy.

2. I now understand how to write proper CREATE TABLE statements with primary and foreign keys to enforce relationships and data integrity.

3. I’ve gotten comfortable using basic SQL commands like SELECT, INSERT, UPDATE, and DELETE to interact with databases.

4. I learned how to read and design Entity-Relationship diagrams, and how those translate into actual table structures.

5. I’ve seen how indexes can make data lookups way faster, especially when dealing with thousands of rows.
   
   

3 questions I still have or need more clarity on:

1. How exactly are indexes structured and stored behind the scenes? Like what data structures are used?

2. What should I consider when designing a database for a really large or growing application?

3. I still want to understand how database transactions work, especially when multiple users access or change data at once.