🧭Data Model
Also known as Data Modeling, Data Modelling
A plan of what data you keep and how the pieces link. It comes before the tables.
Think of it like
It is like the plan for a house. You draw the rooms before you build the walls.
Example
A gym draws a model with members, classes and bookings. Each booking links one member to one class.
Why it matters
A bad model makes every query harder. Fixing it once data is in costs far more than drawing it well first.
Definition
Common mistake
Key takeaways
- 1Things. Name what you track.
- 2Facts. List what you keep about each one.
- 3Links. Show how the things connect.