**DATABASE THEORY**

James Morgan keeps a table of data about the stores from which he purchases. The stores are located in different countries and have different specialties. Consider the following relation:

STORE (StoreName, City, Country, OwnerName, Specialty)

Explain the conditions under which each of the following is true: 1. StoreName > City 2. City > StoreName 3. City > Country 4. (StoreName, Country) > (City, OwnerName) 5. (City, Specialty) > StoreName 6. OwnerName >> StoreName 7. StoreName >> Specialty

1. Specify which of the dependencies above seem most appropriate for a small importexport business. 2. Given your assumptions in B.1, transform the STORE table into a set of tables that are in both 4NF and BCNF. Indicate the primary keys, candidate keys, foreign keys, and referential integrity constraints.