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 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, 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. 1. Produce an Entity Relationship diagram of the Grand Villa Hotels system described abov

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

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 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, 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.

1. Produce an Entity Relationship diagram of the Grand Villa Hotels system described above.

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Distributed Database Concepts
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-engineering and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY