Question
**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
**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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started