Answer Happy

Consider the following scenario from your textbook on page 118dealing with a chain of hotels that need to manage the bookings oftheir guests into rooms at specific hotels in the chain. The hotelchain maintains four tables in order to manage this information:Hotel(hotelNo, hotelName, city) Room(roomNo, hotelNo, type, price)Booking(hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest(guestNo,guestName, guestAddress, guestPhoneNo, guestEmail) The underlinedattribute(s) of each relation form the primary key of the relation.a. Identify foreign key relations in the tables that will allow theappropriate referential integrity rules to be applied. For eachforeign key relation, specify the referring table, the primarytable, and the attributes that form the foreign key in thereferring table. For example, a guest should not be booked into anon-existing room at a hotel. A guest should not be booked into aroom unless there is information about the guest.