Lab_02_normalization - 210.02 Lab Page. 1 210.02 - Data...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
210.02 Lab Page. 1 210.02 Lab 210.02 - Data Normalization Lab Data Normalization Basics 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 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. 5. Save the document and upload the file in the course communication space drop-box. Step 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/02/2009 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Summer '08 term at Pennsylvania State University, University Park.

Page1 / 7

Lab_02_normalization - 210.02 Lab Page. 1 210.02 - Data...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online