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.

TABLE 4-8 Shipment Relation Shipments 409 618 723 824 629 Origin Destination Distance Seattle Denver Chicago Dallas Boston Atlanta Denver Los Angeles Seattle 1,537 1,058 1,214 975 Denver 1,537