Question

HOTEL (hid, name, housingtype, numberofstars, location) ROOM (rid, roomtype, price, floortype, hid) RESERVATION (rid, gid) GUEST (gid, firstname, lastname, birthdate, contactno) By using the given diagram above, write a function named "GET_ROOMDETAILS" to return total price of the rooms with given hotel location. Parameter part of the function is up to you. Use "NO_DATA_FOUND" exception.

          HOTEL (hid, name, housingtype, numberofstars, location)
ROOM (rid, roomtype, price, floortype, hid)
RESERVATION (rid, gid)
GUEST (gid, firstname, lastname, birthdate, contactno)
By using the given diagram above, write a function named "GET_ROOMDETAILS" to return total price of the rooms with given hotel location. Parameter part of the
function is up to you. Use "NO_DATA_FOUND" exception.

HOTEL (hid, name, housingtype, numberofstars, location)
ROOM (rid, roomtype, price, floortype, hid)
RESERVATION (rid, gid)
GUEST (gid, firstname, lastname, birthdate, contactno)
By using the given diagram above, write a function named "GETROOMDETAILS" to return total price of the rooms with given hotel location. Parameter part of the
function is up to you. Use "NODATAFOUND" exception.

Added by Mohamed W.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Lottie Adams

Step 1

First, we need to retrieve the hotel ID(s) for the given hotel location. We can do this by querying the HOTEL table using the location parameter. Show more…

Show all steps

Thanks for your feedback!

HOTEL (hid, name, housing type, number of stars, location) ROOM (rid, room type, price, floor type, hid) RESERVATION (rid, gid) GUEST (gid, first name, last name, birth date, contact no) By using the given diagram above, write a function named "GET_ROOMDETAILS" to return the total price of the rooms with the given hotel location. The parameter part of the function is up to you. Use "NO_DATA_FOUND" exception.