Logical Data Model Template
Documenting the logical data model with attributes, types, and normalisation rules without committing to physical storage
The Logical Data Model template provides a structured approach to documenting the logical data model with attributes, types, and normalisation rules without committing to physical storage.
Template Sections
This template includes 7 sections.
Logical Model Overview
Describe how the logical model extends the conceptual model, the normalisation approach, and any denormalisation...
Logical Data Model Diagram
Diagram section
Entity Attributes
Define the attributes of each entity: name, data type, constraints (required, unique, valid values), and business...
Data Modelling Principles
State the logical modelling principles: normalisation level, naming conventions, key generation strategy, and audit...
Model Constraints
Document constraints on the logical model: referential integrity rules, cascade behaviours, and business rules enforced...
Model Change Impact
Document how changes to the logical model affect downstream systems: application code, reports, integrations, and data...
Logical Model Risks
Document risks: over-normalisation causing performance issues, under-normalisation causing anomalies, and model drift...
Section Details
Block Types Used
| Section | Block Type | Purpose |
|---|---|---|
| Logical Model Overview | Rich Text | Describe how the logical model extends the conceptual model, the normalisation... |
| Logical Data Model Diagram | Diagram | Diagram section |
| Entity Attributes | Data Dictionary | Define the attributes of each entity: name, data type, constraints (required,... |
| Data Modelling Principles | Principle | State the logical modelling principles: normalisation level, naming... |
| Model Constraints | Constraint | Document constraints on the logical model: referential integrity rules, cascade... |
| Model Change Impact | Change Impact | Document how changes to the logical model affect downstream systems:... |
| Logical Model Risks | Risk | Document risks: over-normalisation causing performance issues,... |
Getting Started
Data Architecture Templates
27 templates for data architecture documentation.
Documentation Templates
188 page templates across seven categories, 88 diagram templates across seven categories, plus seven general-purpose document templates.