This module provides students with instruction in the basics of normalizing a logical data design. To be able to normalize a database, students need to understand primary and foreign keys and how to use keys to represent relationships between entities. This module teaches students how to normalize data only to third normal form. | Instructor Notes Module 5 Normalizing the Logical Data Design Introduction Presentation This module provides students with instruction in the basics of normalizing a 60 Minutes logical data design. To be able to normalize a database students need to understand primary and foreign keys and how to use keys to represent ACaV eS relationships between entities. This module teaches students how to normalize 50 Minutes data only to third normal form. After completing this module students will be able to Use primary and foreign keys to implement relationships between entities. Explain the benefits of normalizing entities. Normalize a table to third normal form. Materials and Preparation This section provides you with the materials and preparation needed to teach this module. Materials To teach this module you will need the following materials Microsoft PowerPoint file Module 5 Normalizing the Logical Data Design Activity Identifying Keys in the Logical Model Activity Normalizing Data Preparation To prepare for this module you should Read all materials for this module. Complete the activities. Be sure you understand the concepts of data normalization. 2 Instructor Notes Module 5 Normalizing the Logical Data Design Activities Activity Identifying Keys in the Logical Model In this exercise students will identify primary foreign and composite keys for a logical data model based on the Ferguson and Bardell Inc. case study. After completing this activity students will be able to Identify primary foreign and composite keys in a logical data model. Select a primary and foreign key type that is appropriate for a given entity. To prepare for the activity 1. Complete the activity. 2. Look at the answers and be able to explain them. Activity Normalizing Data In this activity students will normalize the logical design from Activity to third normal form. After completing this activity students will be able to Normalize a logical data design to third .
