ITEC 340
Database I
Homework 6
The following table which is being maintained shows information on adjuncts and the classes they teach.
Only the first few rows of the table are shown.
SalesOrders
OrderNum Date CustID Lname Fname ShipMethod Qty1 Item1 Desc1  Price1  Qty2 Item2 Desc2 Price2 Qty3 Item3 Desc3 Price3
1001 1/1/2003 1 Jones Tom UPS 3 ww White Widget      10.00 3 ew Econo Widget      8.00 4 tw Turbo Widget     21.00
1002 1/3/2003 2 Smith William PICK UP 2 fw Flaming Widget      15.00 4 ew Econo Widget      8.00        
1003 1/3/2003 4 Jones Tom UPS 3 ww White Widget      10.00 8 tw Turbo Widget    21.00        
1004 1/5/2003 3 Thomas Sara US MAIL 2 ew Econo Widget        8.00                
1005 1/5/2003 1 Jones Tom US MAIL 4 fw Flaming Widget      15.00                
1006 1/11/2003 2 Smith William UPS 5 tw Turbo Widget      21.00 2 ww White Widget    10.00        
1007 1/12/2003 5 Maddox  Susan UPS 3 tw Turbo Widget      21.00 1 fw Flaming Widget    15.00        
1008 1/14/2003 6 Maddox Harry PICK UP 2 ww White Widget      10.00 11 tw Turbo Widget    21.00        
1009 1/14/2003 1 Jones Tom UPS 1 fw Flaming Widget      15.00 3 tw Turbo Widget    21.00 12 ww White Widget     10.00
1010 1/14/2003 2 Smith William US MAIL 2 tw Turbo Widget      21.00                
1011 1/16/2003 3 Thomas Sara UPS 5 fw Flaming Widget      15.00 6 ww White Widget    10.00 10 ew Econo Widget       8.00
1012 1/18/2003 6 Maddox Harry UPS 4 tw Turbo Widget      21.00 5 fw Flaming Widget    15.00        
1013 1/18/2003 7 Stevens Bill UPS 3 ww White Widget      10.00 5 ew Econo Widget      8.00        
Please note that customer 1 and customer 4 have the same name. Desc is an abbreviation for description and qty is an abbreviation for Quantity.
Perform lossless decomposition on the table above such that the resulting relations are in at least BCNF.  There are multiple NF violations in the table.
Show the same sample data in your normalized tables.
Make sure you identify all Primary Keys in your solution.
Name your resulting tables.
Create a folder named RU06 in your ITEC 340 student folder.
Name the spreadsheet Normalization.xls
Have the spreadsheet in your RU06 folder by 5:00 p.m. on Friday, March 31st.