Question: We've created a small sample database to use for this assignment. It contains four relations: Person(name, age, gender) // name is a key Frequents(name, pizzeria)
We've created a small sample database to use for this assignment. It contains four relations:
Person(name, age, gender) // name is a key Frequents(name, pizzeria) // [name,pizzeria] is a key Eats(name, pizza) // [name,pizza] is a key Serves(pizzeria, pizza, price) // [pizzeria,pizza] is a key
1)Find all pizzas eaten by at least one female over the age of 20.
2)Find all pizzas that are eaten only by people younger than 24, or that cost less than $10 everywhere they're served.
3)Find the age of the oldest person (or people) who eat mushroom pizza. (This query is quite challenging; congratulations if you get it right.)
4)
Find all pizzerias that serve every pizza eaten by people over 30. (This query is very challenging; extra congratulations if you get it right.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
