Computer Science Homework Help

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)

where

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;

and

Guest 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.