Case study ctts - milestone 05 data model normalization

Case Study CTTS - Milestone 05 Data Model Normalization
Download Document
Showing pages : 1 - 3 of 4
This preview has blurred sections. Sign up to view the full version! View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: SADM 7/ed CTTS CASE STUDY - Milestone 5: Data Model Normalization Page: 5-1 Prepared by Gary B. Randolph for Systems Analysis & Design Methods 7ed by J. L. Whitten, L. D. Bentley, & K. C. Dittman Copyright Irwin/McGraw-Hill 2007 MILESTONE 5 DATA MODEL NORMALIZATION Synopsis n this milestone you will normalize the data model created in Milestone 4, along with additional data requirements, to be in third normal form. Objectives After completing this milestone, you should be able to: Normalize a logical data model to remove impurities that can make a database unstable, inflexible, and non-scalable. Prerequisites 1. Data analysis - Chapter 8 2. Milestone 4 Solution Assignment The goal of this project is to normalize our logical data model to remove impurities that can make a database unstable, inflexible, and non-scalable. I SADM 7/ed CTTS CASE STUDY - Milestone 5: Data Model Normalization Page: 5-2 Prepared by Gary B. Randolph for Systems Analysis & Design Methods 7ed by J. L. Whitten, L. D. Bentley, & K. C. Dittman Copyright Irwin/McGraw-Hill 2007 Activities 1. To construct an Entity Relationship Diagram to be in 3 rd Normal form, follow the normalization procedure outlined in Chapter 8 of the SADM 7 th ed. textbook. Use feedback from your the ERD solution of Milestone 4 as well as the data dictionary provided at the end of this milestone to prepare the new data model. ...
View Full Document