Design a database schema for an e-commerce platform, explaining your choices for tables, relationships, data types, and constraints.

Sample answer preview

Designing an e-commerce database schema demonstrates how schema design principles come together in a real-world application. The design must handle products, customers, orders, inventory, and pricing while maintaining data integrity and supporting efficient query patterns.