Capstone: Design a Schema

Part of the PostgreSQL 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 product, and you have to decide what the tables are, which columns can be null, what happens when a user is deleted, and which of the queries the product will run are going to be slow. That is the skill this capstone is for.

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. ...