Scenario Mr. Morgan has a multiple table of data about the stores from where he makes purchases for his import/export business.

See the following tables:

ITEMS (ItemName, DatePurchased, City, Country, StoreName, StoreOwnerName, StoreSpecialty, Salesperson, Price)

There may be multiple stores within each city

There may be multiple cities within each country

An owner may own multiple stores

There is only one store for each specialty within each city

Stores may have more than one specialty

SHIPMENT (ShipmentNumber, ShipperName, ShipperContactPerson, ShipperPhone, DepartureDate, ArrivalDate, CountryOfOrigin, Destination, ShipmentCost, InsuranceValue, Insurer)

ShipmentNumber is unique

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

The InsuranceValue is always the same for a given shipper and country of origin

Create a Word document to address the following:

1) Identify the functional and multivalued dependencies for these tables. 2) Do each of these tables meet the requirements to be a relation? Why or Why not? 3)Create the appropriate set of related relations in BCNF. Identify the primary keys, candidate keys, foreign keys, and referential integrity constraints for each relation.