A. Morgan keeps a table of data about the stores from which he purchases. The st
ID: 3530051 • Letter: A
Question
A. 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 are 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 B. With regard to the relation in part A: 1. Specify which of the dependencies in part A seem most appropriate for a small importExplanation / Answer
Store
Name
City
Country
Owner
Specialty
Ken & Sue's
Durango
USA
Ken
cheese
Ken & Sue's
Durango
USA
Ken
wine
Ken & Sue's
Durango
USA
Sue
cheese
Ken & Sue's
Durango
USA
Sue
wine
Pascal's Winery
Paris
France
Pascal
bread
Pascal's Winery
Paris
France
Pascal
cheese
Pascal's Winery
Paris
France
Pascal
wine
Purgatory Sports
Durango
USA
Purgatory
skis
River Sports
Turin
Italy
Michael
kayaks
Ski Barn
Durango
USA
Jurgen
skis
Ski Barn
Durango
USA
Jurgen
snowboards
Susie's
London
England
Susie
cheese
Explain the conditions under which the following are true:
1. Name
Store
Name
City
Country
Owner
Specialty
Ken & Sue's
Durango
USA
Ken
cheese
Ken & Sue's
Durango
USA
Ken
wine
Ken & Sue's
Durango
USA
Sue
cheese
Ken & Sue's
Durango
USA
Sue
wine
Pascal's Winery
Paris
France
Pascal
bread
Pascal's Winery
Paris
France
Pascal
cheese
Pascal's Winery
Paris
France
Pascal
wine
Purgatory Sports
Durango
USA
Purgatory
skis
River Sports
Turin
Italy
Michael
kayaks
Ski Barn
Durango
USA
Jurgen
skis
Ski Barn
Durango
USA
Jurgen
snowboards
Susie's
London
England
Susie
cheese
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.