Requirements
- Identify core entities, relationships, and constraints.
- Normalize the schema to at least third normal form.
- Write SQL for table creation, seed data, and five analytical queries.
- Explain indexing choices for common lookup patterns.
Deliverables
Entity relationship diagram.
SQL schema and query file.
Design memo explaining assumptions and constraints.
Assessment focus
1
Normalization quality.
2
Constraint coverage.
3
Query correctness.
4
Practicality of design assumptions.