Sunday, April 12, 2020

Database levels modeling


Database levels Modeling


There are three levels of data modeling: conceptual data model, logical data model, and physical data model.

Feature Conceptual Logical Physical
Entity Names ? ?  
Entity Relationships ? ?  
Attributes / Column   ?  
Primary Keys   ? ?
Foreign Keys   ? ?
Table Names     ?
Column Names     ?
Column Data Types     ?

Conceptual Data Model

Database modeling levels

'Conceptual schema' is a high-level design of business information. It typically includes only the main concepts and the main relationships among them.

Logical Data Model

Logical Data Model

Contains logical information, data, and groups.

Physical Data Model

Contains everything required to create databases and tables, such as column names and data types.

https://www.guru99.com/data-modelling-conceptual-logical.html

Popular Posts