Online_Shopping_System

Online_Shopping_System

This project demonstrates an online shopping system developed as part of a DBMS course. It includes:

1. ER Model: Comprehensive entity-relationship diagram for the system.
2. Relational Model: Mapping of ER model to relational tables.
3. Normalization: Data normalization up to the 3rd Normal Form.
4. SQL Queries: Includes table creation, data insertion, and various complex queries with joins.
5. Views: Created views for customer orders and product categories.

The project showcases essential e-commerce functionalities through well-designed database structures and queries.