Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Information And Database Systems 12th Asian Conference ACIIDS 2020 Phuket Thailand March 23 26 2020 Proceedings

Authors: Pawel Sitek ,Marcin Pietranik ,Marek Krotkiewicz ,Chutimet Srinilta

1st Edition

9811533792, 978-9811533792

More Books

Students also viewed these Databases questions