Question

In: Computer Science

Build a conceptional model for a Hotel Management System. The solution should be presented as an...

Build a conceptional model for a Hotel Management System. The solution should be presented as an ER-diagram. Base your design on the following requirements.

• The database should record information about Customer, Hotel, Booking, Rooms, Employee, Feedback, and Payments.

• A Customer has a name which consists of firstName, middleName and lastName. Customers are identified by a unique customerID. A Customer has an Address, phoneNo and email address – Customers can place any number of Bookings (including none). Customer may provide Feedback for each Booking they have placed (optional). For every Booking, a Booking has to make a Payment. Customer is associated with at least one address and multiple customer can live in the same place.

• A Room is identified by its number and has a type, and a description. – Rooms are part of a Hotel.

• A hotel is identified by it is name and address ID and has a stars rating

• A Booking is uniquely identified by a bookingId. A Booking is created by a Customer. For each booking we store a Total Amount of reserved rooms, and a price for room on the booked day, period and a Date. – A Booking is associated with one or more Rooms. For each Room in a Booking, we have to record how many of the Room type is reserved for the stay, for example (2 Queen, 1 king bedroom and a suite). A booking is a made at one hotel, some hotels may not have any booking.

• Employee is identified by an employee number. An employee works in one or more hotels. An employee has a name and address and birth year. In each hotel you have a permanent employee taking a yearly salary and temporary employee working on hourly rates.

• An Address consists of a unique addrID, street and has streetNumber, city, state and zipcode. The attributes city and state can be derived from the attribute zipcode. – There may be some Addresses which are not be associated with any Customer or Hotel.

• A Payment is identified by the Booking for which the payment was made. It consists of the amountPaid and paymentMethod (Credit Card, E-Check, etc.

Solutions

Expert Solution

consideration included in the diagram

since the employee can be a permanent employee or a temporary one.

So in the Employee table we have created an attribute say Employee_type

Yearly_salary can be set as NULL if the Employee_type is Temporary

Or you may include the is-a relationship from Employee to create two subclass(Extended ER diagram)


Related Solutions

using c++ You have been contracted to build a hotel reservation system. This is the system...
using c++ You have been contracted to build a hotel reservation system. This is the system that hotel desk clerks will use to take desk reservations. Assumptions: This is acting as though the only reservations taken are at the desk. All reservations are for one night. The hotel is empty when you start the program. First, this program will give the full inventory of rooms in the hotel. Total rooms: 122 There are four types of rooms with these prices:...
C PROGRAMMING Build a hotel management program. The user will register their name and put their...
C PROGRAMMING Build a hotel management program. The user will register their name and put their check-in time and check-out time. They can choose their type of room they stay (Deluxe room, junior suite room, suite room, presidential suite room). Then, the program will determine the total price. *NOTE - Using modular, user-friendly, and array usage programming. Please don't use struct/structure and pointer. - Please give explanation about the code.
This is a hotel room and guest management system, the main purpose of this procedure is to manage the room
 IN C.This is a hotel room and guest management system, the main purpose of this procedure is to manage the room, manage the guest account and check the hotel performance (how many rooms are booked, etc.). There are two types of people who use this system, the manager and the receptionist.As a manager, there are three options:Set/adjust room levels and rates for each levelDetail: there are 80 rooms in the hotel, 10 on each floor, eight floors. All rooms have...
The management of an international hotel chain, ABC Suites, intends to set up a system of...
The management of an international hotel chain, ABC Suites, intends to set up a system of certification for all their employees. They are focussed on four areas: customer service, proficiency in tools, workplace health and safety and operational profitability. Pick any TWO areas and suggest what contents can be included in each section. All employees will have to be certified in the every section over two years. You may model your answers in the following manner. Level 1 is the...
1- Assume that you are going to build up a model for a system where unit...
1- Assume that you are going to build up a model for a system where unit operation and unit processes are carried out. Explain the various steps involved in the process of model building for the system you have chosen.
PROBLEM In the Hotel management domain, we have the following concepts: Hotel Hotel chain Hotel room  ...
PROBLEM In the Hotel management domain, we have the following concepts: Hotel Hotel chain Hotel room       Reservation Hilton Hilton San Diego Bayfront Meeting room Ballroom Guest Room Catering Service Internet Service       TV Service Guest Parking Service       Item on bill       You are asked to design a model, using a UML class diagram to relate the abovementioned concepts: Correctly use UML notations for relations such as generalization, association, aggregation, composition. Be careful to distinguish objects from classes. You...
The Cody Hotel, a proposed 50-room hotel (rooms-only lodging facility), planned to build in mid-Michigan. The...
The Cody Hotel, a proposed 50-room hotel (rooms-only lodging facility), planned to build in mid-Michigan. The owner is concerned about the average daily room rate (ADR), construction costs, borrowing costs, and their impact on profits. He provides you with the following information: Determine the required ADR to achieve the owner's goal of earning an ROI of 15%. (20 points) Investment $800,000 Debt $1,500,000 ROI 20% Interest rate 8% Income tax rate 20% Property taxes $100,000 Fire insurances $30,000 Depreciation $200,000...
In the modelling of energy system, similarity should be maintained between model and actual system. Describe...
In the modelling of energy system, similarity should be maintained between model and actual system. Describe different methods to compare similarities with dimensionless number.
project question: 'Design and build a thrust measurement system for model aircraft engines ' 1- Questions...
project question: 'Design and build a thrust measurement system for model aircraft engines ' 1- Questions i) sketch ii) ideas iii) plan iv) introduction, background, theory , abstract etc...
Build an Earned Value Management (EVM) model using these variables: Planned Value: $45,000 i.Note for understanding,...
Build an Earned Value Management (EVM) model using these variables: Planned Value: $45,000 i.Note for understanding, this based on time, and what we expected to use based on time.  Your schedule variance is based on earned and planned. Actual Cost: $39,500 Earned Value (how much has been spent based on planned costs) : $43,500 i.Note for understanding, this usually based on expected costs at the task level.  In other words, for the tasks complete the project was expected to use this much...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT