Use the information in the following table to develop a relational model in third normal form. Document the process of moving from first to second, and finally to third normal form.

 

Order No	Order Date	Cust No	Cust Name	Prod No	Prod Name	Qty	Unit Price
1212	04/22/98	15556	John Doe	222	Tiles (bone)	25 boxes	6.95
				225	Border Tiles	1 box	55.95
				230	Bull nose	1 box	16.95
				110	Grout	1 lb. bag	12.95
1213	04/22/98	25222	Robin Clark	511	Threshold	1	85.00
1214	04/29/98	15556	John Doe	512	Threshold	1	125
				520	Granite Tiles	40	10.95
1215	04/29/98	25252	Carla Jones	224	Tiles (blush)	30 boxes	6.95
				230	Bull nose	2 boxes	16.95
				110	Grout	1 box	12.95