# Data Model

> A plan of what data you keep and how the pieces link. It comes before the tables.

**Field:** Data Engineering  
**Category:** Foundations  
**Also known as:** Data Modeling, Data Modelling

## Think of it like

It is like the plan for a house. You draw the rooms before you build the walls.

## 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.

## 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.

## Common mistake

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

## Three principles

- **Things.** Name what you track.
- **Facts.** List what you keep about each one.
- **Links.** Show how the things connect.

## Related terms

- [Conceptual Data Model](https://learn.benibix.com/term/data/conceptual-data-model)
- [Logical Data Model](https://learn.benibix.com/term/data/logical-data-model)
- [Physical Data Model](https://learn.benibix.com/term/data/physical-data-model)
- [Database Schema](https://learn.benibix.com/term/development/schema)
- [Database Normalization](https://learn.benibix.com/term/development/normalization)
- [Entity-Relationship Diagram (ERD)](https://learn.benibix.com/term/data/entity-relationship-diagram)

## Taught in

- [Data Models and ER Diagrams](https://learn.benibix.com/learn/data-foundations/data-models-and-er-diagrams): Data Engineering Basics, 9/11

![Three boxes from left to right with more detail in each: a conceptual model with just Customer and Order, a logical model that adds fields and keys, and a physical model with real column types.](https://learn.benibix.com/diagrams/data-model-levels.svg)

---

Source: https://learn.benibix.com/term/data/data-model
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-20
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
