This preview has intentionally blurred parts. Sign up to view the full document

View Full Document

Unformatted Document Excerpt

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

End of Preview

Sign up now to access the rest of the document