Expert answer:Week5 Assignment1 – A Stored Procedure to List Full Details of all Hotels in London in the Hotel DatabaseThe following tables form part of a database held in a relational DBMS:- Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest (guestNo, guestName, guestAddress)whereHotel contains hotel details and hotelNo is the primary key;Room contains room details for each hotel and (roomNo, hotelNo) forms the primary key;Booking contains details of the bookings and (hotelNo, guestNo, dateFrom) forms the primary key;andGuest contains guest details and guestNo is the primary key.Create a stored procedure to list full details of all hotels in London.Deliverables:Your answers should be 2-3 pages in length, follow the APA format, and free of grammatical and spelling errors.Once complete, post your paper in a Word Document in the assignment dropbox.
