Question: In a simple database, there are six (6) tables. The database keeps track of restaurants, their owners, customers and their favorite foods. In particular, an
In a simple database, there are six (6) tables. The database keeps track of restaurants, their owners, customers and their favorite foods. In particular, an owner can own several restaurants. In each restaurant different types of foods are served. Different customers of the restaurant like different types of foods. The database schema is as follows:

Provide a relational algebra for the following queries:
a) List phone numbers that are recorded both for the restaurant and the owner phone (you cannot use JOIN for this question)
b) List name of owners who live in the same city that Mr. Jacob (name of one of the owners) lives.
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 (SSN [pk], Name, City, Address, Phone)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
