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.

Hi, this question is SQL related. The following tables form part of

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!