Whenever you're ready, walk me through how you'd approach this.
How would you design a schema to track customer order history and shipping status at Amazon?
Explain the core entities, relationships, keys, constraints, and status-history approach. Discuss how the design supports split shipments, reliable historical reporting, and efficient customer-facing lookups.