Consider a database with the following relations: Hotel (Hotel ID, H_Name, H_Address, H_City, Maximum_Capacity) Gues
Posted: Tue Jul 12, 2022 8:17 am
Consider a database with the following relations:
Hotel (Hotel ID, H_Name, H_Address, H_City,Maximum_Capacity)
Guest (Guest_ID, G_Name, G_Address, G_City)
Room (Hotel_ID, Room_Number, Type,Price_Per_Night)
Booking (Guest_ID, Hotel_ID, Room_Number, From_Date,To_Date, Number_of_Nights)
Display Guests (by name) who booked more than 5 nights betweenJanuary 1st, 2022 (included) and March 1st, 2022 (included).
Hotel (Hotel ID, H_Name, H_Address, H_City,Maximum_Capacity)
Guest (Guest_ID, G_Name, G_Address, G_City)
Room (Hotel_ID, Room_Number, Type,Price_Per_Night)
Booking (Guest_ID, Hotel_ID, Room_Number, From_Date,To_Date, Number_of_Nights)
Display Guests (by name) who booked more than 5 nights betweenJanuary 1st, 2022 (included) and March 1st, 2022 (included).