SQL Database Design & Queries
Relational schema design, normalization, and query logic demonstrated using a multi-entity order system. Includes ERD and table definitions.
- Normalized relational schema (3NF)
- Multi-table joins across orders, customers, and dishes
- Time-series aggregation for revenue analysis
- Query design aligned with reporting use cases