Do it in UNF, 1NF, 2NF, 3NF

SAMPLE REPORTS AND SCREENS ABC MANUFACTURING ORDER FORM DATE: AUG 30,2002 ORDER # 9932 MR SD KURTZ 123 THAT STREET TORONTO, ONTARIO AGB 8C7 SHIPPING ADORESS 455 NO STREET HAMILTON, ONTARIO LSK 5J4 PHONE: (416) 879 0045 (416) 786-3241 ITEME PRODUCT CODE DESCRIPTION 1 FR223 HALF SZE REFRIGERATOR 2 CUSTOMER DISCOUNT: 3% QTY BACKORDERED FILLED PRICEUNIT AMOUNT TB101PATIO TABLE CH089 PATIO CHAIRS 2 750.99 3 150 00 20 35.00 1501.98 450 20 700.00 TOTAL 2651.98 DISCOUNT AMIT 9.55 AMOUNT OWING 2572.42 PRODUCTS INVENTORY AS AT: AUG 30, 2002 CH089 FR223 TB101 PATIO CHAIRS HALF SIZE REFRIGERATOR PATIO TABLE 140 10 35.00 750.99 35.00 ABC MANUFACTURING PRODUCT EXPLOSION REPORT CHO89 PATIO CHAIRS 1X2-30 WOOD 1 25 SCREWS SCRW110 TB101 PATIO TABLE WOOD995 SCRN110 2X4.48 woOD 1.25" SCREWS 12 34 SAMPLE REPORTS AND SCREENS ABC MANUFACTURING ORDER FORM DATE: AUG 30,2002 ORDER # 9932 MR SD KURTZ 123 THAT STREET TORONTO, ONTARIO AGB 8C7 SHIPPING ADORESS 455 NO STREET HAMILTON, ONTARIO LSK 5J4 PHONE: (416) 879 0045 (416) 786-3241 ITEME PRODUCT CODE DESCRIPTION 1 FR223 HALF SZE REFRIGERATOR 2 CUSTOMER DISCOUNT: 3% QTY BACKORDERED FILLED PRICEUNIT AMOUNT TB101PATIO TABLE CH089 PATIO CHAIRS 2 750.99 3 150 00 20 35.00 1501.98 450 20 700.00 TOTAL 2651.98 DISCOUNT AMIT 9.55 AMOUNT OWING 2572.42 PRODUCTS INVENTORY AS AT: AUG 30, 2002 CH089 FR223 TB101 PATIO CHAIRS HALF SIZE REFRIGERATOR PATIO TABLE 140 10 35.00 750.99 35.00 ABC MANUFACTURING PRODUCT EXPLOSION REPORT CHO89 PATIO CHAIRS 1X2-30 WOOD 1 25 SCREWS SCRW110 TB101 PATIO TABLE WOOD995 SCRN110 2X4.48 woOD 1.25" SCREWS 12 34