IST 210 LAB #2 Normalization - IST 210 Lab# 2 Normalization...

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

View Full Document Right Arrow Icon
IST 210 Lab# 2 Normalization STEP 1 Consider the below table with records for three unique ORDER_IDs. Provide three reasons why we normalize tables. Three reasons would be to eliminate any redundancy throughout the database, inconsistencies, and keep the data secure. ORDER _ID Dat e CUST_I D CUST_NA ME Stat e ITEM_NA ME ITEM_DESCRIPT ION QUANTI TY PRIC E 1001 7/7 A004 GEORGE VA 6531 7890 7956 TAPE TABLE PENS 5 1 1 100.0 0 400.0 0 2.00 1002 7/8 A999 BEN PA 3456 STOVE 1 300.0 0 1003 7/9 A201 TOM PA 4234 7956 PAPER PENS 15 10 234.0 0 20.00 STEP 2 First Normal Form prohibits repeating groups, such as, ITEM_NUM, ITEM_DESCRIP, and PRICE. To convert the table to First Normal Form: 1. Remove the repeating groups from the base table. 2. Create a new table with the Primary Key of the base table and the repeating group. Convert the unnormalized table shown in Step 1 to the First Normal Form. Note: We completed the ORDER table as an example of how you should proceed. All you need to do is create the other table and provide the Table name, column names, and appropriate
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 10/20/2011 for the course IT 210 taught by Professor Hoober during the Fall '10 term at Pennsylvania State University, University Park.

Page1 / 5

IST 210 LAB #2 Normalization - IST 210 Lab# 2 Normalization...

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