E-commerce Database (Database Design Project)

E-commerce Database

Designed a complete Entity Relationship Diagram (ERD) for an e-commerce system including users, products, orders, payments, carts, markets, and shipping services.

Converted the ERD into a fully structured Relational Database Schema with proper primary keys and foreign keys.

Implemented many-to-many relationships using junction tables such as order_products, cart_products, and favorites.

Modeled core e-commerce workflows including cart management, product listing, order placement, payment processing, and delivery tracking.

Ensured database normalization and logical structure to support scalability, performance, and real-world business operations.

Designed the system to support key features such as multi-market product listing, category organization, shipping address management, and driver/shipping company integration.