The logical data design is the middle stage of the natural progression from conceptual design to physical design. The process of deriving a logical data design from the conceptual data design accomplishes the following: Translates conceptual data needs into real data requirements. You must turn the conceptual data needs identified during conceptual design into actual entities and relationships that will define how the data interacts. Helps organize your thinking about the data. You must ensure that the data elements identified in the conceptual design stage accurately depict the desired data for the business solution. Focuses on the semantic details of the data relationships. You are forced to delve deeper into. | Module 4 Deriving a Logical Data Design Module 4 Deriving a Logical Data Design 67 Overview Slide Objective To provide an overview of the module topics and objectives. Lead-in In this module you will learn about logical data design and entity relationship modeling. Logical Data Design Entities and Attributes Data Relationships Entity Relationship Modeling Review At the end of this module you will be able to Analyze data requirements to determine data entities and attributes. Analyze data entities and attributes to determine their relationships. Determine the cardinality and existence characteristics of a relationship. Create an entity relationship .
