USE SQL Functions / Procedures

I need help to make an event reservation with the input parameters: hotelid, guestsname, startdate, enddate, dateofresveravtion, numberofattendees, and event type. and the output as eventreservation ID. The second sql I need is to find an event reservation with the input as the guestsname, date, and hotelid. then the output would be the eventreservationid.

Rooms Room Number Hotel ID Hotels Zipcode City State Phone Number Service ID Service name Service cost Reservation Billing Billing # Room charge Misc charges Credit card No Payment Date Customer ID ReservationNumber Check in date Check out date Status Guest fname Guest Iname Room Type Number of guests Reservation date Hotel ID Service ID Room Number Sold Hotel ID Customer ID Last Name Phone number First Name City State Zip code