Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Provide a relational algebra for the following queries. Hi all, I have completed the first 6 questions but having trouble with the more complicated ones.
Provide a relational algebra for the following queries.
Hi all, I have completed the first 6 questions but having trouble with the more complicated ones. Thanks
DATABASE: RESTAURANT (Restaurant_name[pk], City, Phone, Owner_SSN[fk]) FOOD (Food_name[pk], Type, Country) CUST (SSN[pk], Name, Birth_year, Fav_food[fk], Gender) LIKES (SSN[fk], Food[fk]) SERVES (Restaurant[fk], Food[fk]) OWNER (SSNIpk], Name, City, Address, Phone) Provide a relational algebra for the following queries: 7) List the name of the restaurants whose owners live in Lafayette. 8) List the name of owners whose restaurants serve food type A" 9) List phone numbers that are recorded both for the restaurant and the owner phone (you cannot use JOIN for this question) 10) List name of owners who live in the same city that Mr. "Henry" (name of one of the owners) livesStep 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