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:

In a simple database, there are six (6) tables. The database keeps

Provide a relational algebra for the following queries:

a) List the name of the restaurants whose owners live in Baton Rouge.

b) List the name of owners whose restaurants serve food type A.

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Relational algebra 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...

Business Case: Sailboats Inc. Montreal St Laurent Sailboats (MSLS) is an agency that rents sailboats. MSLS does not own the boats but rents them on behalf of sailboat owners. Owners can be companies...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

Architecture design : describe three popular architecture options and explain which one would best apply to Kuddler. 1,000 words. 1 Service Request SR-kf-013 Paper XXXXXXXXX 2 Service Request...

DB DESIGN CASE--DAYTON ART GALLERY General Description Dayton Art Gallery accepts works by living contemporary artists to be sold on a commission basis. It currently offers work from about 100...

2-Shown is a Si NPN BJT at 300K, with the following specifications: 1 m N 0.5 jum Wa N C In the emitter Nor=-10 cm", Leg=2 m, T-8X10 sec, In the base, the Doping NAB varies linearly from 10 atx=0 to...

A Dutch company exporting to France had FF 3 million due in 90 days. Suppose that the spot exchange rate was FF 1 = DFl 0.3291. a. Under the exchange rate mechanism, and assuming central rates of FF...

An office machine is purchased for $ 8 1 0 0 . Under certain assumptions, its salvage value, V , in dollars, is depreciated according to a method called double declining balance, by basically 7 8 %...

Calculate and enter the ending balance for each t-account. Post each transaction from the T-account into the ledger. Enter the transactions in chronological order. Explanations and posting references...

Prepare a targeted rsum in chronological format to apply for one of the positions you found on the Internet in Application Exercise 7.Partner with a classmate to proofread each others rsum. Submit...

In this Application Exercise, you will be doing the groundwork for an oral presentation to your classmates. First, identify which of the presentation topics listed below you will use. Second, analyze...

Teamwork. Technology. Global. Each member in a group of three should locate an article related to some aspect of global business or business communication. Randomly assign the style (manuscript,...