A Stored Procedure to List Full Details of all Hotels in London in the Hotel Database?
Week5 Assignment1 – A Stored Procedure to List Full Details of all Hotels in London in the Hotel Database
The 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)
Hotel 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;
Guest contains guest details and guestNo is the primary key.
Create a stored procedure to list full details of all hotels in London.
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.