CST363: Introduction to Database, Week 4

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

1. Database Design Basics- Learned how to identify entities, attributes, and relationships when building a database. 
2. Keys and Constraints- I've learned how primary keys uniquely identify records, how foreign keys connect tables, and how constraints like NOT NULL make sure data is consistent and valid.
3. SQL Queries- Practiced using queries such as SELECT, INSERT, DELETE, and UPDATE to retrieve and change data.
4. Joins- Learned about the different types of joins (inner, left, right) to combine data across multiple tables. 
5. Views- I've learned that views are like saved queries to make complex data easier to work with. 

List at least 3 questions you still have about databases.

1. How do you decide when to normalize a database further? At what point does normalizing too much make queries slower or more complex?
2. What are the best practices for indexing to make queries faster without using too much storage?
3. How are real-world databases protected against data corruption? Do organizations use logging or checkpoints?