Complete SQL Database Design and Implementation for an E‑commerce Store

This project involved designing a full relational database for an e‑commerce store, from analysis to query implementation.

Tasks completed:

- Created an ERD (Entity Relationship Diagram) showing all tables and relationships.

- Designed 8 tables: Customers, CustomerPhone, Category, Products, productColor, Orders, orderItems, payment, orderPayment.

- Defined Primary Keys and Foreign Keys with proper constraints.

- Wrote DDL statements (CREATE TABLE) with NOT NULL, UNIQUE, and FK constraints.

- Inserted sample data using INSERT statements.

- Wrote 7 complex SQL queries including:

* Total sales per customer.

* Best‑selling products.

* Late orders.

* Monthly sales reports.

- Designed a simple GUI (optional) for managing customers and products.

Deliverables: ready‑to‑run SQL script, ERD diagram, explanation report.