Question: CHATGPT does not work import database ( found below ) on RelaX and do the following Write the relational algebra expression for the following queries
CHATGPT does not work
import databasefound below on RelaX and do the following
Write the relational algebra expression for the following queries using the syntax on RelaX.
Provide the output of the expression schema of the table and content
Verify the solution on Relax.
Personname age, gender name is PK
Frequentsname pizzerianamepizzeria is PK
Eatsname pizzanamepizza is PK
Servespizzeria pizza, pricepizzeriapizza is PK
a Find all pizzerias frequented by at least one person under the age of
b Find all pizzas eaten by at least one female over the age of
c Find pizzerias frequented by teenagers eating mushroom or pepperoni. A teenager is a person of age
d Find pizzerias frequented by teenagers eating mushroom and pepperoni.
e Find the names of all females who eat at least one pizza served by Mod Pizza.
f Find all pizzerias that serve at least one pizza for less than $ that both Amy and Fay eat.
g Find the names of all people who eat at least one pizza served by Dominos but who do not frequent Dominos.
h Find all pizzas that are eaten only by people younger than or that cost less than $ everywhere they're served.
i Find the age of the youngest person or people who eat pepperoni pizza.
j Find all pizzerias that serve pizzas only eaten by people over
k Find all pizzerias that serve every pizza eaten by people over
l Find all pizzerias that serve the cheapest cheese pizza.
m Find all pizzerias exactly serving only two pizzas.
Database:
group: pizzas
Person
name:string, age:number, gender:string
Amy, female
Ben, male
Cal, male
Dan, male
Eli, male
Fay, female
Gus, male
Hil, female
Ian, male
Eats
name:string, pizza:string
Amy, mushroom
Amy, pepperoni
Ben, cheese
Ben, pepperoni
Cal, supreme
Dan, cheese
Dan, mushroom
Dan, pepperoni
Dan, sausage
Dan, supreme
Eli, cheese
Eli, supreme
Fay, mushroom
Gus, cheese
Gus, mushroom
Gus, supreme
Hil, cheese
Hil, supreme
Ian, pepperoni
Ian, supreme
Frequents
name:string, pizzeria:string
Amy, "Pizza Hut"
Ben, "Papa Jones"
Ben, "Pizza Hut"
Cal, "Christians Pizza"
Cal, "Mod Pizza"
Dan, "Christians Pizza"
Dan, "Mod Pizza"
Eli, "Papa Jones"
Eli, "Mod Pizza"
Fay, "Dominos"
Fay, "Little Caesars"
Gus, "Papa Jones"
Gus, "Pizza Hut"
Hil, "Dominos"
Hil, "Pizza Hut"
Hil, "Mod Pizza"
Ian, "Dominos"
Ian, "Christians Pizza"
Ian, "Mod Pizza"
Serves
pizzeria:string, pizza:string, price:number
"Papa Jones", cheese,
"Papa Jones", supreme,
"Dominos", cheese,
"Dominos", mushroom,
"Little Caesars", cheese,
"Little Caesars", mushroom,
"Little Caesars", pepperoni,
"Little Caesars", sausage,
"Christians Pizza", cheese,
"Christians Pizza", pepperoni,
"Christians Pizza", supreme,
"Pizza Hut", cheese,
"Pizza Hut", pepperoni,
"Pizza Hut", sausage,
"Pizza Hut", supreme,
"Mod Pizza", cheese,
"Mod Pizza", pepperoni,
"Mod Pizza", sausage,
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
