Case 24 Data Model Normalization.docVIP

MILESTONE 4 – DATA MODEL NORMALIZATION Synopsis In this milestone you will normalize the data model created in Milestone 3, 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 nonscalable. Prerequisites Data analysis — Chapter 7. Milestone 3 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 nonscalable. Activities To construct an Entity Relationship Diagram to be in third normal form, follow the normalization procedure outlined in Chapter 7 of the SADM 5th ed. textbook. Use the ERD solution of Milestone 3 as well as the data dictionary provided at the end of this milestone to prepare the new data model. Make assumptions where necessary. Your instructor will specify deliverable format and software to be used. Deliverables should be neatly packaged in a binder, separated with a tab divider labeled “Milestone 4.” References: Milestone 3 Solution: The Key-Based Data Model Diagram Provided by your instructor. Eudrup Tool Crib System Data Attribute Dictionary Provided at the end of this milestone. Refer to a Copy of Your Fully Attributed Data Model Created for Milestone 3. Deliverables: Logical Data Model in Third Normal Form: Due: __/__/__ Time:_______ Milestone’s Point Value: _______ Eudrup Tool Crib System Data Attribute Dictionary [NOTE! The following contains descriptions of attributes that are to be stored in the Tool Crib System. It is quite common for users to volunteer new or additional attributes they would like a new system to store. Thus, the following list contains those attributes that were either mentioned or appeared on forms throughout the prior milestones, AND it contains descriptions of some new attributes th