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
a diagram that represents the database design
a more detailed diagram than the entity-relationship diagram in that it fills in details about the process flow that the entity-relationship diagram attempts to model
a representation of both the data elements used by an enterprise and the relationships between those data elements
The LDM is a logical data structure diagram plus a structured description of each entity and relationship. Each entity’s attributes (e.g. stock code, min stock holding, min order quantity, product description, primary identifier) are recorded.
Derives from the Conceptual data model. Data is fully attributed and normalized.
A model that represents the true structure of data, independent of software or hardware implementation constraints.
A graphical representation of the way a business organizes its information. It is not a database, and is platform-independent. It is a logical and unbiased representation of the business data. The data model defines which individual data elements exist and how they relate to one another. It provides an accurate map of business information. The LDM is designed to answer all of the required business questions, both known and future that may arise in the business.
In computer science, a logical data model is an abstract DBMS-independent representation of a set of data entities and their relationships within the scope of a system.
