Sports Equipment Pro Shop: Inventory Management. Welcome to the team, data architect. The Pro Shop is days from its grand opening with 5,000+ products across dozens of sports categories, and it needs a database that can track inventory, suppliers, and sales from day one. Marcus (inventory) wants real-time stock visibility; Sophia (sales) wants to know what's selling fastest. Your job is the data model underneath both.
You'll work three short puzzles below — relationship types, a sales fact table, and column data types — that together sketch a clean retail star schema.
What the shop tracks
- Products — organized by category, brand, sport, and supplier.
- Customers — who's buying, for loyalty and analytics.
- Sales — the transaction fact: which product sold, to whom, when, for how much.
The techniques you'll practice
- Relationship cardinality — telling one-to-many from many-to-many.
- Fact-table design — separating dimension keys from measures.
- Data types — picking the right type for each column.
How to work the project
Each puzzle below gives you a pool of items and the buckets they belong in. Pick an item, click its bucket, then Check answer. Reveal the worked solution at the end to compare against a reference retail model. The in-page tutor can talk through any decision with you.