Designing an E-commerce Platform

A product manager describes the store in one sentence. "A customer browses products, places an order, pays for it, tracks the delivery, and leaves a review."

That sentence holds most of the design. This case study turns it into entities, then into tables, then into SQL that runs.

What the system must do

Seven capabilities, taken from what the store actually offers.

Manage customers, with their contact details and their saved addresses.

Hold a catalog of products, grouped into categories, with stock counts.