Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Murach's SQL Server 2012 For Developers

Authors: Bryan Syverson, Joel Murach, Mike Murach

1st Edition

1890774693, 9781890774691

More Books

Students also viewed these Databases questions