Could any one please answer the following question. Pleasesend the solution as s

Question

Could any one please answer the following question. Pleasesend the solution as soon as possible. Given the database schema as following, please finish thefollowing SQLs: Hotel (hotelNo, hotelName, city) Room (RoomNo, hotelNo, type, price) Booking (hotelNo, guestNo, dataFrom, dataTo,roomNo) Guest(guestNo, guestName, guestAddress) 1.) List full details of all hotels. 2.) List the names and addresses of all guests in London,alphabetcally ordered by name. Please reply asp. Thank you Could any one please answer the following question. Pleasesend the solution as soon as possible. Given the database schema as following, please finish thefollowing SQLs: Hotel (hotelNo, hotelName, city) Room (RoomNo, hotelNo, type, price) Booking (hotelNo, guestNo, dataFrom, dataTo,roomNo) Guest(guestNo, guestName, guestAddress) 1.) List full details of all hotels. 2.) List the names and addresses of all guests in London,alphabetcally ordered by name. Please reply asp. Thank you

Explanation / Answer

1) SELECT * FROM Hotel 2) SELECT Guest.guestName, Guest.guestAddress     FROM Guest, Booking, Hotel     WHERE (Guest.guestNo= Booking.GuestNo) AND(Booking.hotelNo = Hotel.hotelNo)                   AND (Hotel.city ='London')     ORDER BY Guest.guestName

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---