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

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, 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)) )

Explanation / Answer

1) It will select all hotel numbers where the price of room is greater than 50$

2) It wii display all hotels having room numbers assigned

3) It is a combination of above 2 Queries. That is will select all hotels that are having room numbers and whose price of room is greater than 50$

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.