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
Step: 1
Get Instant Access to Expert-Tailored 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