Normalized and fully attributed logical data model
This project-specific logical data model is a fully normalized entity-relationship diagram showing kernel entities, associative entities, characteristic entities, cardinality, optionality, unique identifiers, and all attributes.
Business meta data
The business entities and attributes from the logical data model must be described with meta data. Data-specific business meta data components include data names , data definitions, data relationships, unique identifiers, data types, data lengths, domains, business rules, policies, and data ownership. These are usually captured in the tool repository of the computer-aided software engineering (CASE) tool.
Data-cleansing specifications
This document describes the cleansing logic that must be applied to the source data in order to bring it into compliance with the technical data conversion rules, the business data domain rules, and the business data integrity rules. This document will be used to create the transformation specifications on the source-to-target mapping document in Step 9, ETL Design.
Expanded enterprise logical data model
This deliverable is produced behind the scenes by data administration or the enterprise architecture group when it merges the project-specific logical data model into the enterprise logical data model. Any rejected entities or attributes and any discrepancies between the models will be presented to the BI project team for resolution.