DATA MODELING
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
An overview of the three main levels of data modeling: Conceptual, Logical, and Physical. The Conceptual Model establishes entities, attributes, and relationships. The Logical Model adds structure and sets relationships between data elements, providing a foundation for the Physical Model. The Physical Model describes the database implementation, generating a schema with meta-data.
Typology: Slides
2019/2020
1 / 7
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Data Modeling: Conceptual, Logical and Physical Levels and more Slides Computer science in PDF only on Docsity!
DATA MODELING
CONCEPTUAL MODEL
The main aim of this model is to establish the
entities, their attributes, and their relationships.
In this Data modeling level, there is hardly any
detail available of the actual Database structure.
LOGICAL MODEL
(^) Logical data models add further information to the conceptual model elements. It defines the structure of the data elements and set the relationships between them. (^) The advantage of the Logical data model is to provide a foundation to form the base for the Physical model. However, the modeling structure remains generic. (^) At this Data Modeling level, no primary or secondary key is defined. At this Data modeling level, you need to verify and adjust the connector details that were set earlier for relationships.