Question: 5 . Consider the database with the following schema: Person ( name , age, gender ) name is key Frequents ( name , iceCreamShop )

5. Consider the database with the following schema:
Person(name, age, gender) name is key
Frequents(name, iceCreamShop)(name, iceCreamShop) is a key
Eats(name, flavor)(name, flavor) is a key
Sells(iceCreamShop, flavor, price)(iceCreamShop, flavor) is a key
U
Find all the ice cream shops where Sara likes at least one of their flavors and each cost less than $3.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!