Week 20

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

1. I've learned about database systems and basics, concepts and designs of a database and how it stores and manages data.

2. Relational model and how data is organized in tables, select, insert, update, and delete rows.

3. Keys and integrity constraints, primary keys, foreign keys, referential integrity, etc. 

4. Complex queries including joins, subqueries, and aggregate functions.

5. Database design and structure, including database design principles, storage media, table structures, and indexing methods.

List at least 3 questions you still have about databases.

1. We skipped chapter 3.9, so what is the full scope and application of relational algebra in database querying?

2. What are the best practices for designing complex queries to optimize performance while maintaining readability?

3. What is cardinality in database design, and how does understanding cardinality impact the way you model relationships between entities?