# Logical Data Model

> The data plan with every field and key added. It is not tied to any one database.

**Field:** Data Engineering  
**Category:** Foundations  
**Also known as:** Logical Model

## Think of it like

It is like a street map. Now you see every road, but not what the roads are made of.

## Definition

A logical data model adds detail to the conceptual one. It lists every field for each thing, such as a customer's name and email. It marks the keys that make each record unique and that link records. It still says nothing about which database you use. The same logical model could be built in any database.

## Example

The library's Loan now has fields: loan ID, member ID, book ID, date out and date due.

## Why it matters

It is the full design you can check before you build. Any database can be built from it.

## Common mistake

Mixing it up with the physical model. Logical says what fields exist. Physical says how one database stores them.

## Three principles

- **Every field.** All the facts for each thing.
- **Keys marked.** Primary and foreign keys are shown.
- **No product yet.** It fits any database.

## Related terms

- [Conceptual Data Model](https://learn.benibix.com/term/data/conceptual-data-model)
- [Physical Data Model](https://learn.benibix.com/term/data/physical-data-model)
- [Primary Key](https://learn.benibix.com/term/development/primary-key)
- [Foreign Key](https://learn.benibix.com/term/development/foreign-key)

## Told apart from

- [Logical Data Model vs Physical Data Model](https://learn.benibix.com/compare/logical-vs-physical-data-model): People think the logical and physical data models are the same drawing. The logical one lists every field and key. It fits any database. The physical one gives each field an exact type for one real database. It also picks the indexes. If you change the database, only the physical model changes.

## Taught in

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

---

Source: https://learn.benibix.com/term/data/logical-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.
