Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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,
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 the bookings and (hotelNo, guestNo, dateFrom) forms the primary key; Guest contains guest details and guestNo is the primary key. Provide SQL queries for the following. 1. How many different guests have made bookings that includes at least one day in September this year ? (2 points) 2. Show the 10 guests with more bookings in the hotels in Barcelona. (2 points) 3. How many room types have each hotel in Madrid. ( 3 points) Provide SQL queries for the following. 1. How many different guests have made bookings that includes at least one day in September this year ? (2 points) 2. Show the 10 guests with more bookings in the hotels in Barcelona. (2 points) 3. How many room types have each hotel in Madrid. (3 points) 4. Insert a new Hotel named "Hotel Royal" in the city of Valencia with the hotelNo 16. (1.5 points) Then update the name of the hotel to "Hotel Mediterraneo" ( 1.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