Capstone: Design an Ecommerce Schema

Part of the MySQL course

Every lesson so far handed you a table and asked you to query it. Real work runs the other way round: somebody describes a shop, and you have to decide what the tables are, which relationships need enforcing, what happens when a product is deleted, and whether creating an order can leave the database half-finished. That is the skill this capstone exercises.

Try each step yourself before reading the version below it. Getting a design slightly wrong and then seeing why is worth more than copying one that works. ...