This project implements the database for any e-commerce application. The design and requirements are based on Amazon's e-commerce website.
The database was created from the ground-up, following the traditional process of:
- Requirements Collection
- ER / EER Diagram Creation
- Mapping the EER Diagram to a Relational Schema Diagram
- Normalizing the Relational Schema to 3NF
- SQL Table Creation Statements
- Addition of foreign key constraints, CHECK clauses, NOT NULL constraints, DEFAULT values, and triggered actions on foreign keys
- Development of relevant stored procedures using PL/SQL
- Development of relevant triggers using PL/SQL
