Answer Happy

6. Consider the following scenario from your textbook on page 118 dealing with a chain of hotels that need to manage the bookings of their guests into rooms at specific hotels in the chain. The hotel chain 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 underlined attribute(s) of each relation form the primary key of the relation. a. Identify foreign key relations in the tables that will allow the appropriate referential integrity rules to be applied. For each foreign key relation, specify the referring table, the primary table, and the attributes that form the foreign key in the referring table. For example, a guest should not be booked into a non-existing room at a hotel. A guest should not be booked into a room unless there is information about the guest.