Logical Data Model, Codes

Definition

The logical data model consists of:

• Entity Relationship Diagram (ERD)
• Entity Type and Attribute descriptions (the "Data Dictionary")
• Codes spreadsheet

The logical data model shows the information needs of the business.  It is designed at the logical level (separated from the physical implementation) as much as possible, however, the automated transformation process used (logical to physical) requires some physical design considerations within the logical model.

Roles and Responsibilities

• SDLC Roles and Responsibilities

Standards

• NRS Data Modelling Standards

Other Applicable standards include:

• Data Naming Standards
• Code Tables
• Custodianship Standards
• Data Administration Standards
• Other Data Administration Standards
• NRS Corporate Oracle Repository Access Procedures
• NRS Developers Working in a Corporate Versioned Repository

Templates

There is no template currently available.

Samples

• Logical Data Model, Codes Samples