Data_Normalization_Exercises__2___IST_21 - Page.1...

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

Page. 1 IST 210 - Data Normalization Exercise Dr. Stan Aungst Fall 2010 Due Date: 11 Oct. 2010 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 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.
Image of page 1

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

Image of page 2
This is the end of the preview. Sign up to access the rest of the document.
  • Spring '08
  • Normal Form, Dr. Stan Aungst, Salesman Primary Commission

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern