World Campus IST210 – Lab #2: Data Normalization Basics
Date Assigned: See Syllabus Date Due: See Syllabus
This lab consists of two exercises that will demonstrate your ability to normalize data using the first three normal forms.
OBJECTIVES After completing this lab, you will be able to:
• Discuss why a table is not in the First Normal Form • Convert an unnormalized table into the First Normal Form • Take a table that is in the First Normal Form and convert it to the Second Normal
Form. • Take a table that is in the Second Normal Form and convert it to the Third Normal
Form. • Identify table keys.
ASSIGNMENT Below are a series of two exercises along with a list of requirements for completing each. In the first activity, you will be required to read through each of the steps and convert an unnormalized table into a normalized table as you create an E-R diagram. In the second activity, you will be required to take an existing E-R diagram and create a database schema.
EXERCISE 1. Normalization of the ORDERS Table The purpose of this exercise is for you to demonstrate your ability to take an unnormalized table and convert it up through the third normal form. Upon completion of this exercise you will have:
• Discussed why the step one table is not normalized • Converted the table in step one to the First Normal Form • Converted the table created in step two into the Second Normal Form • Converted the table created in step three into the Third Normal Form • Identified all of the names, attributes, and keys associated with each of the tables
EXERCISE 1 DIRECTIONS To complete exercise one, you should do the following:
1. Read and complete each of the four steps identified under exercise one 2. Create a response for each step listed under exercise one 3. Create your response in MS Word 4. When appropriate, use the table feature within Word to create your tables.