CapstonePlanLesson 65 / 69

Design the data model

Exercise45 min

Design the data model

Before any code, draw the schema — you have trained for exactly this:

  1. 1.Spot the entities (the nouns worth remembering).
  2. 2.Pick keys and the relationships between them.
  3. 3.Normalize until every fact lives once.
  4. 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