Pizza Planet Party: Galactic Data Modeling. Greetings, data astronaut. Pizza Planet is throwing the biggest cosmic pizza festival in the galaxy — astronauts, aliens, and explorers warping in from every system. Chef Basil runs the kitchen; Chef Coriander runs the delivery fleet. They need a data model that's simple but powerful enough to track every customer, every pizza, and every warp-speed delivery.
This is a gentle introduction to dimensional modeling: you'll build two dimensions and a single fact table, then type every column correctly. Three short puzzles below, one clean star schema at the end.
The source you're modeling
- Customers — the aliens and astronauts placing orders.
- Pizzas — the menu of cosmic pies.
- Deliveries — the transaction fact: who ordered which pizza, when, and for how many space credits.
The techniques you'll practice
- Surrogate keys — stable integer keys for
dim_customersanddim_pizzas, with the natural IDs kept as attributes. - A single fact table —
fact_deliveriesat one row per delivery, with foreign keys plus a date and a measure. - Data types — the right type for every column (INT, VARCHAR, DATE, DECIMAL).
How to work the mission
Each puzzle below gives you a pool of columns and the tables they belong in. Pick a column, click its table, then Check answer. Reveal the worked solution at the end to compare against a reference model. The in-page tutor can walk through any modeling choice with you.