Table 4-8 shows a portion of a shipment table for a large manufacturing company. Each shipment… 1 answer below »

Table 4-8 shows a portion of a shipment table for a large manufacturing company. Each shipment (identified by Shipment#) uniquely identifies the shipment Origin, Destination, and Distance. The shipment Origin and Destination pair also uniquely identifies the Distance.

a. Develop a diagram that shows the functional dependencies in the SHIPMENT relation.

b. In what normal form is SHIPMENT? Why?

c. Convert SHIPMENT to third normal form if necessary. Show the resulting table(s) with the sample data presented in SHIPMENT.

 

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer