The logical data model is a high-level business view of the data stored in a database presented in diagram form. It shows the actual tables that contain the information in the database and how they are related to each other. English-like business names are used to label the tables instead of shorter abbreviated physical table names (i.e., â€œPerson Historyâ€ instead of â€œT_PERS_HISTâ€). The logical data model is very useful for determining what data is available. ()
An abstract formal representation of the categories of data and their relationships in the form of a diagram, such as an entity-relationship diagram. A logical data model is process independent, which means that it is fully normalized, and therefore does not represent a process dependent (e.g. access-path) database schema.
a collection of tables, columns, and relationships bounded by a schema