This project demonstrates an online shopping system developed as part of a DBMS course. It includes:
- ER Model: Comprehensive entity-relationship diagram for the system.
- Relational Model: Mapping of ER model to relational tables.
- Normalization: Data normalization up to the 3rd Normal Form.
- SQL Queries: Includes table creation, data insertion, and various complex queries with joins.
- Views: Created views for customer orders and product categories.
The project showcases essential e-commerce functionalities through well-designed database structures and queries.