Stored Procedure, computer science assignment 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)


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.


"Is this question part of your assignment? We can help"