Skip to content
BENIBIX Learn

Data Model

Data🧭 FoundationsData Modeling

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

A data model is a plan for how data is laid out. It names the things you track, such as customers and orders. It lists what you store about each one. It also shows how they link, such as one customer having many orders. Data modeling is the work of drawing that plan before the tables are built.
The same plan, drawn three times. Each level adds detail.

Common mistake

Jumping straight to tables. The plan is where you find out a member can book many classes.

Key takeaways

  1. 1
    Things. Name what you track.
  2. 2
    Facts. List what you keep about each one.
  3. 3
    Links. Show how the things connect.

Learn it properly