Design a relational schema for an e-commerce app (users, products, orders, inventory).

Answer preview

Start with entities and relationships, then add constraints that protect money and inventory. Interviewers want to see normalization, keys, and one concurrency story.…