BCS543
NORMALIZATION EXERCISE

Value: 5% (part of PBL marks)
Due Date: Sept. 23rd .

Data Normalization Basics

This exercise consists of two exercises that will demonstrate your ability to normalize data using the first three normal forms.

Objectives

After completing this exercise, 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 following activities, you will be required to read through each of the steps and convert an unnormalized table into a normalized table.

Exercise I. 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.

Step 1

Consider the