Explore BrainMass

Explore BrainMass

    Relational Algebra Expression

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    The following tables form part of a database held in a relational DBMS:
    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 bookings and (hotelNo, guestNo, dateFrom) forms the primary key;
    Guest contains guest details and guestNo is the primary key.

    Generate the relational algebra expressions for the following queries:

    (a) List all hotels.
    (b) List all single rooms with a price below $20 per night.
    (c) List the names and cities of all guests.
    (d) List the price and type of all rooms at the Grosvenor Hotel.
    (e) List all guests currently staying at the Grosvenor Hotel.
    (f) List the details of all rooms at the Grosvenor Hotel, including the name of the guest staying in the room, if the room is occupied.
    (g) List the guest details (guestNo, guestName, and guestAddress) of all guests staying at the Grosvenor Hotel.

    © BrainMass Inc. brainmass.com November 24, 2022, 11:46 am ad1c9bdddf

    Solution Summary

    Arelational algebra expression is formulated.