Difference between Conceptual and Physical Data Model
Conceptual Data Model:
The conceptual data model describes different types of data stored in a database. It also includes the relationships existing among data items. In this data model, a database is also described logically rather than physically in terms of data structure.
Physical Data Model:
Physical Data Model is the one closest to the physical storage device. Because it describes how data are stored on a storage medium such as a hard disk, magnetic tape, etc. It also defines compression and encryption techniques.
Conceptual vs Physical Data Model:
|Parameters||Conceptual Data Model||Physical Data Model|
|Owner||1. Business Stakeholders & Team members||1. Database Administrator & Developers|
|Complexity||2. Simple||2. Complex|
|Entity Names & Relationship||3. Presented||3. Not presented|
|Primary & Foreign Keys||4. Not presented||4. Presented|
|Table & Column Names||5. Not presented||5. Presented|
|Column Data Type & Constraints||6. Not presented||6. Presented|