How would you design a database schema for an e-commerce application? Walk through your approach and key decisions.

Sample answer preview

## Step 1: Identify Core Entities For an e-commerce app, the main entities are: - Users (customers, admins) - Products (with categories) - Orders (with line items) - Payments - Reviews ## Step 2: Define Relationships ``` Users ──1:N──> Orders ──1:N──> Order Items <──N:1──…