This is my er diagram for a hotel management system. I need help writing three procedures/functions in PL SQL. Should I make adjustments to my er diagram? Really confused on hw to write code for these procedures/functions. Any help would be appreciated.

Make a reservation: Input parameters: Hotel, guests name, start date, end dates, room type, date of reservation, etc. Output: reservation ID . NOTE: Only one guest per reservation. However, the same guest can make multiple reservations.

Find a reservation: Input is guests name and date, hotel ID. Output is reservation ID

Cancel a reservation: Input the reservationID and mark the reservation as cancelled (do NOT delete it)

Hotels Rooms m NumberPK> Zipcode City State Phone Number Room Type Rates Room location Number of beds Customer ID Reservation SPK2 Check in date Check out date Status Number of guests Reservation date Room Number Billing Customer Billing # Room charge Misc charges Credit card No Payment Date omer ID Last Name Phone number First Name City State Zip code Services ervice ID PK> Service_name Service cost Reservation Number Customer ID