Design the data model
Exercise45 min
Design the data model
Before any code, draw the schema — you have trained for exactly this:
- 1.Spot the entities (the nouns worth remembering).
- 2.Pick keys and the relationships between them.
- 3.Normalize until every fact lives once.
- 4.Diagram it, and check it answers your app's main question.
Use the diagram lab from this roadmap: design it there, review it like a real engineer would, and keep the diagram as your source of truth. When the schema is right, the API is a translation exercise.
Exercise
Design your capstone's schema in the diagram lab. It must include at least one many-to-many with data on the join.
Practice in the diagram lab
This lesson's practice belongs in the diagram editor — design the schema you just read about, grade it against the solution, and save it to your account.
Open the diagram lab