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 Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter4: Entity Relationship (er) Modeling

Section: Chapter Questions

Problem 10P

See similar textbooks

Similar questions

When a prospective student wants to obtain more information about an educational institution and the courses they offer, they will phone the institution and make an appointment with a student advisor. When the appointment is made, the prospective student’s name, surname and contact number is recorded. After the appointment has taken place, the student advisor will record the key conversation points that were addressed during the meeting. The student advisor’s manager can then pull a report of the number of prospective students consulted and the type of questions they asked.”Q.2.1 Provide an example of a computer system. Q.2.2 Explain the role that the various components of a computer system will play in the scenario provided at the beginning of the question. Identify and explain the three basic operations performed by computers. Q.2.4 Identify one input device that a student advisor will use to capture the details of a prospective student.
Topic Management Information System Please to create a chart base on the information below cross functional interactions chart for a recovery policy request The Policy Change Request process diagram should start with the client submitting a request for a change in coverage to the customer service department. The customer service representative will verify the client's information and send the request to the Finance department for approval. Once approved, the IT department will update the client's deduction amount in the system and notify the Marketing department to update the client's policy premium. The Finance department will also notify the client's employer of the updated deduction amount.
Star Award Trophy Company is a multinational corporation which engages in the design, manufacturing, and worldwide marketing and sale of trophies. The trophies are designed and manufactured mainly for sports or other forms of company events such as team building, concert, competition and other planned event. The trophy designs are standard but could be customized based on the customer request. The customers can add logo, name and plan the design with the designer, once confirmation is established, the trophy will be manufactured and distributed. The company was founded in the year 1990 and its manufacturing network consists of over 100 factories in 10 countries. Each product moves from 20 distribution centres across a network of 9,000 accounts and 60,000 retail outlets. Q) It is very important to know customer’s needs for market sustainability. To have a positive relationship with customers, Star Award Trophy Company decided to implement Customer Relationship Management System.…
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?
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.
The method for creating a service plan
Please to create a chart base on the information below cross functional interactions chart for a recovery policy request Please show the satrt and end on the chart it a recovery Policy request The Policy Change Request process diagram should start with the client submitting a request for a change in coverage to the customer service department. The customer service representative will verify the client's information and send the request to the accounts department for approval. Once approved, the IT department will update the client's deduction amount in the system and notify the Marketing department to update the client's policy premium. The Finance department will also notify the client's employer of the updated deduction amount.
Draw a activity Diagram: Actors Use Cases Use Case Description Customer Login Tesco appointment website Customer must login Tesco website and choose the appointment tab to start. Choose Tesco Branch Location Customer will have to choose a Tesco branch of their choice. Fill in personal information Customer will have to input name, phone number or email and ID verification View available date and time slots Customer must look at available dates and time Tesco currently offers Select date and time slot Customer will have to choose date and time of their choice subject to availability at Tesco. Receive confirmation with QR code Customer will receive confirmation of appointment along with QR code to present to Tesco clerk. Appointment System Verify customer’s phone number or email System will cross-check if the customer registered with a legit number or email by sending OTP. Generate QR code for booking System will generate…
Entities of hotel management and their attributes
When you create a new job category – Select one: a. all employees are assigned to the new category initially b. no employees are assigned to new category initially c. all employees in this category are not salespersons initially d. you cannot assign an employee from another category to the new category at the same time.
A company is reviewing the jobs of graphic designers, secretaries, and line manager of the customer relation department. Fill in the table below to Identify one Job Analysis methods that you think suitable for each job and Why they are suitable. JOB Suitable job Analysis Method Why the method is suitable Line Manager Secretary Graphic designer
List the activities, number of people required and the time (in days) required for each activity of ecommerce project. Be specific with details. For example, if you are going to collect data, indicate specifically who you are going to collect data from?