Question: A hotel uses a booking system that needs to store, per booking, the room num- ber, the duration of the booking (start date, end

A hotel uses a booking system that needs to store, per booking,

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.

Step by Step Solution

3.45 Rating (158 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!