Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following tables form part of a database held in a relational DBMS:- where Hotel contains hotel details and hotelNo is the primary key; Room
The following tables form part of a database held in a relational DBMS:- 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, roomNo) forms the primary key; Guest contains guest details and guestNo is the primary key. Provide Relational Algebra queries for the following. 1. Retrieve the guests (guestNo, guestName) with guestName bigger alphabetically than "Smith", ( 1.5 points) 2. Retrieve all Bookings, with info from the room and hotel (GuestName, HotelName, roomNo, type, price, dateFrom, dateTo) in the city of Lisboa ( 1.5 points) 3. Retrieve all hotel names (HotelName) without reservations. ( 2.5 points) 2. Retrieve all Bookings, with info from the room and hotel (GuestName, HotelName, roomNo, type, price, dateFrom, dateTo) in the city of Lisboa ( 1.5 points) 3. Retrieve all hotel names (HotelName) without reservations. ( 2.5 points) 4. Retrieve names of all guests (guestName) who have booked in ALL the hotels in London. (2.5 points)
Step 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