What is logical data modeling?
Logical data modeling is the process of representing data architecture and organization in a graphical manner, regardless of the physical implementation or database management system technology involved in storing the data. A logical data model provides all information about the various entities and the relationships between the entities in a database.
A logical data model represents the organization of a data set by standardizing the people, places, things (entities) and the rules and relationships between them using a standard language and notation. It provides a conceptual abstract overview of the structure of the data.
Logical data modeling does not provide any information about how the structure should be implemented or which means (technologies) are required to implement the data structure shown. It is a technology-independent data model that is developed from the initial structures identified by the conceptual data model. Some of the information provided by a logical data model includes the following:
- Attributes of entities
- Key groups (primary key, foreign key)