What Is a Logical Data Model?
As a graphical representation of the information requirements for a given business area, a logical data model is constructed by taking the data descriptions depicted in a conceptual data model and introducing associated elements, definitions and greater context for the data’s structure.
This stage is important because while the more streamlined conceptual data model is more easily communicated, the lack of context can make it difficult to move from modeling to implementation. More detail is required to support that progression.
Such detail includes defining the owned attributes, primary keys, foreign keys, relationship cardinality and describing entities and classes. At this stage, the nature of relationships between data is established and defined, and data from different systems is normalized.