rand 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
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
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
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.
1A. Create a Context-Level Data Flow Diagram for the Grand Villa Hotels new system. (You may make any non-contradictory assumptions about the data to and from the central process)
1B. Produce an Entity Relationship diagram of the Grand Villa Hotels system described above.
1C. Draw a Use Case diagram for the Grand Villa Hotels system.
Step by step
Solved in 2 steps with 2 images
