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, –...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. 1. 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)

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
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,
–...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.

1. 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)

Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Database Development
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education