There are three levels of data modeling, conceptual data model, logical data model, and physical data mode.
Feature | Conceptual | Logical | Physical |
Entity Names | ✓ | ✓ | |
Entity Relationships | ✓ | ✓ | |
Attributes /Column | ✓ | ||
Primary Keys | ✓ | ✓ | |
Foreign Keys | ✓ | ✓ | |
Table Names | ✓ | ||
Column Names | ✓ | ||
Column Data Types | ✓ |
Conceptual Data Model
‘Conceptual schema’ is a high-level design of a business information. It typically includes only the main concepts and the main relationships among them.
Logical Data Model
Contains logical information data and groups.
Physical Data Model
Contains every things which require to create database and tables like column name and data type.
https://www.guru99.com/data-modelling-conceptual-logical.html