This project demonstrates an E-commerce database using SQL.
- customersp
- productsp
- ordersp
- orderdetailssp
- One-to-Many → Customers → Orders
- Many-to-Many → Orders ↔ Products
- Joins
- Aggregations
- Business queries
Run SQL scripts in this order:
- schema.sql
- data.sql
- queries.sql
This project simulates a real-world E-commerce system and demonstrates how SQL can be used to generate business insights from raw data.