normalization.txt

SSD7练习6答案

1.
	primary key:EmpID
2.
	EmpID->EmpName,OrderNo,ShipToAddr,ShippedDate,TrackingNum
	OrderNo->ShipToAddr
	OrderNo->TrackingNum
3.
	 since the OrderNo and ShipToAddr are repeated for each SHIPMENT, 
	 when modifying ShipToAddr to other address for OrderNo, there 
	 is a possibility that the other row might not be modified. In 
	 that case the table would show that the same OrderNo has two ship
	 to address
4.

5.
	1NF:
		EmpID  EmpName  OrderNo     ShipToAddr         ShippedDate  TrackingNum
 		 1234     Joe     223     4615 Forbes Ave     12/21/99     12435678
 					  Pittsburgh, PA 15147