Write a relational algebra expression

Assignment Help Computer Engineering

Reference no: EM132122261

The relations given below are part of a database schema for a hotel management system. Assume that these relations have been populated with suitable data as appropriate, and the underlined attribute is a primary key.

Hotel (hotelNo, hotelName, city)

Room (roomNo, hotelNo, type, price)

Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)

Guest (guestNo, guestName, guestAddress)

where Hotel contains hotel details and hotelNo is the primary key;

Room contains room details for each hotel and (roomNo, hotelNo) forms the primary key;

Booking contains details of the bookings and (hotelNo, guestNo, dateFrom) forms the primary key; and

Guest contains guest details and guestNo is the primary key.

Write a relational algebra expression for each of the following data retrieval requirement:

(i) Produce a relation containing the hotel number of those hotels with a room price greater than £50.

(ii) Produce a relation containing the details of all rooms at all hotels.

(iii) Produce a relation containing all hotel names with a room price below £100.

(iv) Produce a relation containing all guests and show the details of any bookings they have beyond 1-Jun-2016.

Reference no: EM132122261

Questions Cloud

Exclusive investments projects : A firm is considering the two mutually exclusive investments projects. Project Alpha requires an initial outlay of $600 and will return $160 per year

What will be the value of? matt account : What will be the value of? Matt's account in 9 years with his quarterly payments if he is earning 6.5?% ?(APR), 11% ?(APR), or 14.5% ?(APR)?

Discuss various versions of unix operating system : Detailed literature review of the features (at-least five) of Unix Operating System. Discuss various versions of Unix Operating System.

What is the npv of project : If the tax rate is 34 percent and the discount rate is 10 percent, what is the NPV of this project? (Assume that dNWC will be fully recovered in the last year o

Write a relational algebra expression : Produce a relation containing all guests and show the details of any bookings they have beyond 1-Jun-2016.

Compute the standard deviation of portfolio : Please enter your answer as a percentage to three decimal places (i.e. 12.345% rather than 0.12345 -- the percent sign is optional).

Define a function called count that takes two strings : Define a function called count_in_file() that takes two strings, a filename and a search string, and returns the number of times that the search string occurs.

Positive npv at the company : The project has a positive NPV at the company's 10.25% cost of capital. Which of the following is closest to the correct IRR? Ignore taxes.

What is a remote procedure call : What is a 'Remote Procedure Call (RPC)'? How a RPC is originated and what are the applications/examples of a RPC process?

User Account

All Pages