Checklist: Logical Data Model
This checklist assesses the completeness of the most detailed state of the Data Model. Initial versions of this artifact at the entity-relationship or conceptual level may not meet all criteria.
Relationships
Related Elements
Check Items
Each entity is logical and not physical
Each entity is relevant to the business and in scope of this project
Each entity and attribute is created and used by a function/ process
Each relationship has correct cardinalities, reflecting business needs
The data model covers all the information the system needs to record about the business
Each entity has a name, a primary key, and one or more attributes
Each entity enters into one or more relationships with other entities
Each entity and attribute is described in the corresponding data dictionary
Each entity is properly normalized to third normal form
The naming and structure are consistent with modeling guidelines