A Stored Procedure to List Full Details of all Hotels in London in the Hotel Database?

/in /by

Don't use plagiarized sources. Get Your Custom Essay on
Need an answer from similar question? You have just landed to the most confidential, trustful essay writing service to order the paper from.
Just from $13/Page
Order Now

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)

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.

Once complete, post your paper in a Word Document in the assignment dropbox.