CS 3310 Assignment #5 Database Design Morgan Importing Problem Complete Solution

A.    Follow the “Assessing Table Structure” procedure shown. List multivalued dependencies,functional dependencies, candidate keys, primary keys, and foreign keys. State yourassumptions.

Answer:

The given database contains two tables which are as given below:

SHIPMENT(ShipmentNumber, Shipper, Phone, Contact, From, Departure, Arrival, Contents, InsuredValue )

ITEM (Item, Date, City, Store, Salesperson, Price)

An attribute that may take on more than one value for a given entity instance is known as multivalued attribute. For example, in SHIPMENT table, phone is multi-value attribute, while in ITEM table, store attribute is multivalued.

Boyce-codd normal form was designed to eliminate dependencies that can because redundancies present in 3NF relations. BCNF has other additional constraints compared to 3NF and is based on the functional dependencies that keep an account of all the candidate keys.Functional dependency is defined as the attribute in the form of non-key. It shows the dependency based upon the functions. It forms the part of the primary key. The functional dependencies of SHIPMENT table are