A hotel uses a booking system that needs to store, per booking, the room num- ber,...

Transcribed Image Text:

A hotel uses a booking system that needs to store, per booking, the room num- ber, the duration of the booking (start date, end date), a reference number for the guest, and finally the reference number (RN) of the employee who made the booking. There are various room types to chose from for every booking. The room types include, for instance, single bedrooms, suites, queen's palace and everything in between. Bookings can be made per room, or a group may book a combination of rooms for their stay. Every room is cleaned by an assigned employee or cleaner. Draw the EERD that will support the business requirements set out above. A hotel uses a booking system that needs to store, per booking, the room num- ber, the duration of the booking (start date, end date), a reference number for the guest, and finally the reference number (RN) of the employee who made the booking. There are various room types to chose from for every booking. The room types include, for instance, single bedrooms, suites, queen's palace and everything in between. Bookings can be made per room, or a group may book a combination of rooms for their stay. Every room is cleaned by an assigned employee or cleaner. Draw the EERD that will support the business requirements set out above.

Answer rating: 100% (QA)

Here is an EERD that can support the business requirements In this EERD there are two main entities ... View the full answer