Logical data model

A logical data model is an abstract representation of a set of data entities and their relationship, usually including their key attributes. It may leave out non-key attributes or use abstractions of actual types, and there may be physical tables that are represented in the logical model by relationships or as aggregates within a larger entity, depending on the notation used and the level of abstraction. The logical data model is intended to facilitate analysis of the function of the data design, and is not intended to be a full representation of the physical database. It is typically produced early in system design, and it is frequently a precursor to the physical data model that documents the actual implementation of the database.