Grand Villa Hotels which is the purported case study used improved manual system in their room booking (i.e., they use Excel sheets as a database for their customers). During interview session with the manager of the hotel, some of the problems that were identified by using the Excel sheet include: a) Lack of immediate retrievals: Since different excel sheets were used to store different transactions e.g., room reservation, food ordering, customer details; it is often hard to retrieve and to find particular information quickly. For example, to find out about the customer’s room booking details, the user has to go through various excel sheets. This results in inconvenience and wastage of time. b) Lack of immediate information storage: The information generated by various transactions takes time and efforts to be stored at the right place. c) Lack of prompt updating: Various changes to information like customer’s details or cancellation of reservation are difficult to make. d) Preparation of accurate and prompt reports: It takes a lot of time to compile information. Grand Villa Hotel is a hotel that started operation on 15th March, 2018. It is located at No.10 Thompson Way, Jabulani Estate, G.E.M.A, Accra. The hotel has one hundred and sixty rooms and is built in a cozy environment with excellent security systems. The hotel has the following types of rooms: Presidential suite, Presidential suite with vintage, Junior suites, Vintage, Vintage executive, Business executive, Diplomatic executive, Deluxe, and Super deluxe. It also has the following facilities: stand-by generator, DSTV, broadband Internet access, bar, –...3/5 swimming pool, laundry services, air-conditioned rooms, telephone and transport for conveying customers to their respective destinations. The hotel is also made up of various degree of staff which includes: the Managing Director, who is the overall manager of the hotel, the General Manager who is in charge of all the transactions carried out by the two managers, that is the Duty Manager and the Operational Manager. The Duty Manager manages the front desk officer and the housekeepers. The front desk officer takes in the customer’s requests and consequently hands them over to the housekeeper who makes sure that the requests are granted by contacting room services, kitchen assistance, cleaners, porter, security and cooks. The Operational Manager controls the marketers, stock controllers and purchasing officers. The hotel currently makes use of the manual system of room reservation. Like the manual system for room booking, the reservation system also has loads of challenges. The management of Grand Villa Hotels have hired you and your team as Systems Analysts to analyze and recommend a new system that will meet the needs of the hotel. QUESTION: 1B. Produce an Entity Relationship diagram of the Grand Villa Hotels system described above.
Read the case study below and answer the questions that follow:
Grand Villa Hotels which is the purported case study used improved manual system in their room booking (i.e., they use Excel sheets as a
Excel sheet include:
a) Lack of immediate retrievals: Since different excel sheets were used to store different transactions e.g., room reservation, food ordering, customer details; it is often hard to retrieve and to find particular information quickly. For example, to find out about the customer’s room booking details, the user has to go through various excel sheets. This
results in inconvenience and wastage of time.
b) Lack of immediate information storage: The information generated by various transactions takes time and efforts to be stored at the right place.
c) Lack of prompt updating: Various changes to information like customer’s details or cancellation of reservation are difficult to make.
d) Preparation of accurate and prompt reports: It takes a lot of time to compile information. Grand Villa Hotel is a hotel that started operation on 15th March, 2018. It is located at No.10 Thompson Way, Jabulani Estate, G.E.M.A, Accra. The hotel has one hundred and sixty rooms and is built in a cozy environment with excellent security systems. The hotel has the following types of rooms: Presidential suite, Presidential suite with vintage, Junior suites, Vintage, Vintage executive, Business executive, Diplomatic executive, Deluxe, and Super deluxe. It also has the following facilities: stand-by generator, DSTV, broadband Internet access, bar, –...3/5
swimming pool, laundry services, air-conditioned rooms, telephone and transport for conveying customers to their respective destinations.
The hotel is also made up of various degree of staff which includes: the Managing Director, who is the overall manager of the hotel, the General Manager who is in charge of all the transactions carried out by the two managers, that is the Duty Manager and the Operational
Manager. The Duty Manager manages the front desk officer and the housekeepers. The front
desk officer takes in the customer’s requests and consequently hands them over to the housekeeper who makes sure that the requests are granted by contacting room services, kitchen assistance, cleaners, porter, security and cooks. The Operational Manager controls the
marketers, stock controllers and purchasing officers.
The hotel currently makes use of the manual system of room reservation. Like the manual system for room booking, the reservation system also has loads of challenges. The management of Grand Villa Hotels have hired you and your team as Systems Analysts to analyze and recommend a new system that will meet the needs of the hotel.
QUESTION:
1B. Produce an Entity Relationship diagram of the Grand Villa Hotels system described above.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
