Scenario $$ Ms$.$ Patel has multiple data tables about puzzles purchased for her business.

ITEMS $($ItemName$,$ QuantityPurchased, DatePurchases, City, Country, SupplierName, PuzzlePieces, PuzzleShape, UnitPrice, SalesPerson$)$

There may be multiple suppliers in each city.

There may be multiple cities within each country.

Puzzles can have more than one shape and number of pieces that make the puzzle.

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:

Identify the functional and multivalued dependencies for these tables.

Do each of these tables meet the requirements to be a relation? Why or Why not?

Create the appropriate set of related relations in BCNF$.$ Identify the primary keys, candidate keys, foreign keys, and referential integrity constraints for each relation.