Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Consider a database with the following schema: Person (name, age, gender) name is a key Frequents ( name, pizzeria) (name, pizzeria) is a key

image text in transcribedimage text in transcribedimage text in transcribed

1. Consider a database with the following schema: 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 Find the costumer names and pizzas for all males over 24 years who frequent at least one time the Straw Hat Pizzeria. Select one or more: On name,pizza (o (gender="male" (Person)mo (Pizzeria='Straw Hat) (Frequents)^(Eats Serves) n name, pizza (o (age>24) (Person)O(Pizzeria='Straw Hat)(Frequents) (Eats Serves)) I name, pizza (Ogender="male")" (age>24) (Pizzeria='Straw Hat) (Person Eats Frequents Serves)) A name, pizza gender="male")" (age>24) (Person) o (Pizzeria="Straw Hat') (Frequents) (Eats Serves)) I name,pizzalogender="male")" (age>24) (Person) (Pizzeria='Straw Hat) (Frequents) (Eats Serves)) Mname, pizza (o gender="male)(Person) O Pizzeria='Straw Hat') (Frequents) (Eats Serves)) Mname, pizzal (age>24)(Person) (Pizzeria='Straw Hat') (Frequents) (Eats Serves)) Person Frequents name Amy Ben Ben Cal Cal Dan Dan Eli Eli name age gender Amy 16 female Ben 21 male Cal 33 male Dan 13 male Eli 45 male 21 female Gus 24 male Hil 30 female lan 18 male pizzeria Pizza Hut Chicago Pizza Pizza Hut New York Pizza Straw Hat New York Pizza Straw Hat Chicago Pizza Straw Hat Dominos Little Caesars Chicago Pizza Pizza Hut Dominos Pizza Hut Straw Hat Dominos New York Pizza Straw Hat Fay Fay Fay Gus Gus Hil Hil Hil lan lan lan Serves Eats name Amy Amy Ben Ben Cal Dan Dan Dan Dan Dan Eli Eli Fay Gus Gus Gus Hil Hil lan lan pizza mushroom pepperoni cheese pepperoni supreme cheese mushroom pepperoni sausage supreme cheese supreme mushroom cheese mushroom supreme cheese supreme pepperoni supreme pizzeria pizza Chicago Pizza cheese Chicago Pizza supreme Dominos cheese Dominos mushroom Little Caesars cheese Little Caesars mushroom Little Caesars pepperoni Little Caesars sausage New York Pizza cheese New York Pizza pepperoni New York Pizza supreme Pizza Hut cheese Pizza Hut pepperoni Pizza Hut sausage Pizza Hut supreme Straw Hat cheese Straw Hat pepperoni Straw Hat sausage price 7.75 8.5 9.75 11 7 9.25 9.75 9.5 7 18 8.5 9 12 12 12 9.25 8 9.75

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

Online Market Research Cost Effective Searching Of The Internet And Online Databases

Authors: John F. Lescher

1st Edition

0201489295, 978-0201489293

Students also viewed these Databases questions

Question

5. If yes, then why?

Answered: 1 week ago

Question

3. What changes should I be making?

Answered: 1 week ago