Question: Hi, this question is SQL related. The following tables form part of a database held in a relational DBMS: Hotel hotelNo, hotelName. City) RoomroomNo, hotelNo,
Hi, this question is SQL related.

The following tables form part of a database held in a relational DBMS: Hotel hotelNo, hotelName. City) RoomroomNo, hotelNo, type, price) Booking(hotelNo, GuestNo. dateFrom. dateTo, roomNo) Guest (guestNo. guestName, guest Address) 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 booking, and ChotelNo, guest No.dateFrom) forms the primary key Guest contains the guest details and guestNo is the primary key Use the Hotel schema defined above and answer following questions a) 1hotelNO (Oprice > 50 (Room) ) b)tel.hotelNa-Room.hotelNa(Hotel Room) c) Hotel Hatel.hotelNo = Room.hotelNo (oprice > 50 (Room)) )
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
