Skip to content
BENIBIX Learn

Logical Data Model

Data🧭 FoundationsData Modeling

Also known as Logical Model

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

Think of it like

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

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.

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.

Common mistake

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

Key takeaways

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

Compare

Learn it properly