Consider the relation:

SHIPMENT (ShipmentNumber, VendorName, VendorContact, VendorFax,

DepartureDate, ArrivalDate, CountryOfOrigin, Destination, ShipmentCost,

InsuranceValue, Insurer)

The following are the functional dependencies and multivalued dependencies for the relation of a small importexport business.

ShipmentNumber -> VendorName

ShipmentNumber ->DepartureDate

ShipmentNumber -> ArrivalDate

ShipmentNumber ->CountryOfOrigin

ShipmentNumber -> Destination

ShipmentNumber ->ShipmentCost

ShipmentNumber -> InsuranceValue

ShipmentNumber ->Insurer

VendorName ->-> VendorContact

VendorName ->-> VendorFax

The cost of a shipment between two cities is always the same.

(CountryOfOrigin, Destination) ->ShipmentCost

The insurance value is always the same for a given vendor and country of origin.

(VendorName, CountryOfOrigin) ->InsuranceValue

Using the 12 functional dependencies listed, transform SHIPMENT into a set of tables in BCNF and 4NF. Indicate the primary keys, candidate keys, foreign keys, and referential integrity constraints.