marymathews/amazon-database-design

Generalized database design for any e-commerce application

Amazon Database Design

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
  • Functional Requirements
• ER / EER Diagram Creation
  • EER Diagram
• Mapping the EER Diagram to a Relational Schema Diagram
• Normalizing the Relational Schema to 3NF
  • Relational Schema
• SQL Table Creation Statements
• Addition of foreign key constraints, CHECK clauses, NOT NULL constraints, DEFAULT values, and triggered actions on foreign keys
  • Table Creation
• Development of relevant stored procedures using PL/SQL
  • Procedures
• Development of relevant triggers using PL/SQL
  • Triggers