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 theirroom booking (i.e., they use Excel sheets as a database for their customers). During interviewsession with the manager of the hotel, some of the problems that were identified by using theExcel sheet include:a) Lack of immediate retrievals: Since different excel sheets were used to store differenttransactions e.g., room reservation, food ordering, customer details; it is often hard toretrieve and to find particular information quickly. For example, to find out about thecustomer's room booking details, the user has to go through various excel sheets. Thisresults in inconvenience and wastage of time.b) Lack of immediate information storage: The information generated by varioustransactions takes time and efforts to be stored at the right place.c) Lack of prompt updating: Various changes to information like customer's details orcancellation 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.10Thompson Way, Jabulani Estate, G.E.M.A, Accra. The hotel has one hundred and sixty roomsand is built in a cozy environment with excellent security systems. The hotel has the followingtypes of rooms: Presidential suite, Presidential suite with vintage, Junior suites, Vintage,Vintage executive, Business executive, Diplomatic executive, Deluxe, and Super deluxe. It alsohas the following facilities: stand-by generator, DSTV, broadband Internet access, bar, swimming pool, laundry services, air-conditioned rooms, telephone and transport forconveying 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 thetransactions carried out by the two managers, that is the Duty Manager and the OperationalManager. The Duty Manager manages the front desk officer and the housekeepers. The frontdesk officer takes in the customer's requests and consequently hands them over to thehousekeeper who makes sure that the requests are granted by contacting room services, kitchenassistance, cleaners, porter, security and cooks. The Operational Manager controls themarketers, stock controllers and purchasing officers.The hotel currently makes use of the manual system of room reservation. Like the manualsystem for room booking, the reservation system also has loads of challenges. The managementof Grand Villa Hotels have hired you and your team as Systems Analysts to analyze andrecommend 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 thecentral process)IB. Produce an Entity Relationship diagram of the Grand Villa Hotels system describedabove.1C. Draw a Use Case diagram for the Grand Villa Hotels system.(Hint - correct use of the <» or <> relationships will attractadditional marks)

the solution is an given below :

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

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

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

See similar textbooks

Similar questions

Topic: Database Design What are some concerns about using a date (or date time) as a primary key?
The use of indices speeds up query processing, although it is usually a terrible idea to establish them for every possible search key. Why?
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…
Scripts and stored procedures are two different kinds of items that may be used in databases. How do their differences from one another manifest themselves? They each engage in a variety of activities. If you want to implement stored procedures, it is strongly recommended that you do it via the usage of a database rather than through any other method.
If adjusting the database's structure is so important, why is it taking so long?
This category includes features of database designs such as program separation, support for numerous users, and the application of catalogs.
A real-world SQL database sample should be provided and explained.
In the absence of specific data, which step is still required to be carried out?
What distinguishes database programming from other programming languages is its focus on data. What specific examples are you able to offer of the things you're talking about?