🧭Logical Data Model
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
Common mistake
Key takeaways
- 1Every field. All the facts for each thing.
- 2Keys marked. Primary and foreign keys are shown.
- 3No product yet. It fits any database.