A production-style relational database designed to simulate a real-world e-commerce platform.
This project demonstrates database design, normalization, and advanced SQL querying.
This database models the core functionality of an e-commerce system, including:
- User management
- Product catalog
- Order processing
- Sales tracking
| Table Name | Description |
|---|---|
| Users | Stores customer information |
| Products | Stores product details |
| Orders | Stores order transactions |
| Order_Items | Stores items within each order |
- One User → Many Orders
- One Order → Many Order_Items
- One Product → Many Order_Items
- ✅ Well-structured relational schema
- ✅ Use of Primary & Foreign Keys
- ✅ Normalized database design
- ✅ Sample data for testing
- ✅ Supports analytical SQL queries.