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

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!