A hotel is a hive of numerous operations such as front office, booking and reservation, banquet, finance, HR, inventory, material management, quality management, security, energy management, housekeeping, CRM and more. Hotel has a number of rooms, and these rooms are of different categories. Based on room category, each room has different price. Hotel has several employees to manage the services provided to customers. Customer can book the room either online or by cash payment at the hotel. Customer record is stored in hotel database which contains customer identity, his address, check in time, check out time etc. hotel provide food and beverages to their customers and generate the bill for this at the time of their check out. Please create an Entity Relationship diagram that captures this information about the system. Be certain to indicate identifiers and cardinality constraints.

A hotel is a hive of numerous operations such as front office, booking and reservation, banquet, finance, HR, inventory, material management, quality management, security, energy management, housekeeping, CRM and more. Hotel has a number of rooms, and these rooms are of different categories. Based on room category, each room has different price. Hotel has several employees to manage the services provided to customers. Customer can book the room either online or by cash payment at the hotel. Customer record is stored in hotel database which contains customer identity, his address, check in time, check out time etc. hotel provide food and beverages to their customers and generate the bill for this at the time of their check out. Please create an Entity Relationship diagram that captures this information about the system. Be certain to indicate identifiers and cardinality constraints.

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

ROI Spreadsheet Create an Excel spreadsheet that depicts Return on Investment (ROI) calculations that support your plan
Computer Science Case Study You are the programmer at a recreation center. This recreation center has a database that tracks classes, enrollment, cancellation, revenues, and expenses for each program or class. The database also tracks customer demographics. What type of evaluation would you conduct on an annual basis using the available data?
ISO 17799 deals with methods to manage and operate systems. True or false
Fordley Car Park is open between 7am and 9pm every day. They charge £2.30 per hour with a minimum fee of one hour and a £2 overnight charge for stays between 9pm and 7.30am. Payments are made at the end of a visit. The car park is also used by resident and business permit holders on the basis of annually renewable membership. All new memberships are registered via the Fordley Car Park website or by completing a form which can be picked up from the car park attendant. Recently Fordley has invested in a paperless attended smart parking system that scans car registration numbers as cars drive through the entrance gate. To ensure that a reading has been captured, the gates only open when a valid registration is read. Exit gates also have a camera which scans the car registration number and will open automatically unless payments are outstanding in which case the payment can be made at the attendant kiosk without leaving the car. Members whose membership has expired can also pay for the…
Please draw Data Flow Diagram of this system Hotel Reservalion System Making Reservations Canceling Reservations Viewing Reservatons Receptionist Customers Editing Reservations Recording Payment
Project Description A telephone book system, also known as a telephone directory, telephone address book, or Phone book, is a listing of telephone subscribers in a geographical area or subscribers to services provided by the organization that publishes the directory. Its purpose is to allow the telephone number of a subscriber identified by name and address to be found. Project Features The features of telephone book system are mainly related to the addition, listing, searching, and modifying telephone directory-related records. All these operations are done through Arrays. The information contained in the telephone directory records are the first name, last name, phone number, city, address, sex and email of the person whose record is entered in the telephone directory system. Project Operations Write a JAVA program that will maintain a phone directory using Arrays. The program should be able to perform the following operations: 1.Add persons details (first name, last name, phone…
Compared to other types of setup, what makes software product configuration unique? Is there a method for having a talk about how configurations are managed?
a) Assuming you have been asked to develop a sales solution for a client who owns a small boutique in Adabraka, explain in generic terms the approach you would use to engineer such as solution.b) For the project in Question 1a, explain the testing option available and how you would use them. c) Your client has indicated that he would be opening more branches in the near future and so will want to use the cloud in the future or have his own private network. Can you explain two applicable security threats his business may face?
An example of IS that has been in use within a company. Please note that there are five functional areas (i.e. five examples) # Name your IS example Vendor Description & Place of use ex1 ex2 ex3 ex4 ex5
North Hills College has decided to implement a new registration system that will allow students to register online as well as in person. As IT manager, you decide to set up a JAD session to help define the requirements for the new system. The North Hills organization is fairly typical, with administrative staff that includes a registrar, a student support and services team, a business office, an IT group, and a number of academic departments. Using this information, you start work on a plan to carry out the JAD session. Who would you invite to the session, and why? What would be your agenda for the session, and what would take place at each stage of the session? Why is the JAD session so important to the task.
Question 6 Your company (a manufacturing firm) is undertaking a software systems development. The system is to support an order management tool to help the company better manage its inventory, purchases and receivables. The system should provide automated notifications when payments from customers have not been received within two weeks of the deadline date and should alert the Finance department when payments by the company to suppliers are within one week of its deadline. The system should also provide a unique id for each item of inventory irrespective of its type. Formal mathematical methods will be used in the development of the system. In the following, choose all statements which are true regarding the application of software quality techniques to the system development. a. Tests should include cases where more than unique id is used for the same item of inventory. b. Inspections will provide a static means of validating the user requirements. C. The formal method can be used to…
COURSE Geographical Information System Only correct answer will be upvoted. Else downvoted.