Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Business scenario: Hotel del Luna is planning to open soon. They are in need of a database system that helps them keep track of their reservations. At any given time, they would like to know which rooms are occupied and which rooms are available. Additionally, data needs to be kept on the employees, specifically the housekeeping, to track when and which rooms are clean and ready to be used. Information such as the employee number and name will be used to determine which housekeepers are in charge of which floors/rooms. Data regarding the room number, beds, maximum number of guests, and price rates must be included in the database. Also, data needs to be kept on each guest who makes a reservation, which room(s) they reserve, and the duration of their stay.

Business scenario: Hotel del Luna is planning to open soon. They are in need of a database system that helps them keep track of their reservations. At any given time, they would like to know which rooms are occupied and which rooms are available. Additionally, data needs to be kept on the employees, specifically the housekeeping, to track when and which rooms are clean and ready to be used. Information such as the employee number and name will be used to determine which housekeepers are in charge of which floors/rooms. Data regarding the room number, beds, maximum number of guests, and price rates must be included in the database. Also, data needs to be kept on each guest who makes a reservation, which room(s) they reserve, and the duration of their stay.

Computer Networking: A Top-Down Approach (7th Edition)
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...
See similar textbooks
icon
Related questions
Question

Please create an ERD diagram (do not hand draw) with the provided information  

Business scenario: Hotel del Luna is planning to open soon. They are in need of a database system that helps them keep track of their reservations. At any given time, they would like to know which rooms are occupied and which rooms are available. Additionally, data needs to be kept on the employees, specifically the housekeeping, to track when and which rooms are clean and ready to be used. Information such as the employee number and name will be used to determine which housekeepers are in charge of which floors/rooms. Data regarding the room number, beds, maximum number of guests, and price rates must be included in the database. Also, data needs to be kept on each guest who makes a reservation, which room(s) they reserve, and the duration of their stay. Business rules: 1. A guest can make only one reservation. 2. A reservation belongs to one and only one guest. 3. A room belongs to only one guest. 4. A guest can reserve many rooms. 5. A room belongs to one and only one reservation. 6. A reservation can reserve one or more rooms. 7. A room is cleaned by one and only one maid. 8. A maid can clean one or more rooms.
Transcribed Image Text:Business scenario: Hotel del Luna is planning to open soon. They are in need of a database system that helps them keep track of their reservations. At any given time, they would like to know which rooms are occupied and which rooms are available. Additionally, data needs to be kept on the employees, specifically the housekeeping, to track when and which rooms are clean and ready to be used. Information such as the employee number and name will be used to determine which housekeepers are in charge of which floors/rooms. Data regarding the room number, beds, maximum number of guests, and price rates must be included in the database. Also, data needs to be kept on each guest who makes a reservation, which room(s) they reserve, and the duration of their stay. Business rules: 1. A guest can make only one reservation. 2. A reservation belongs to one and only one guest. 3. A room belongs to only one guest. 4. A guest can reserve many rooms. 5. A room belongs to one and only one reservation. 6. A reservation can reserve one or more rooms. 7. A room is cleaned by one and only one maid. 8. A maid can clean one or more rooms.
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
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
SEE MORE TEXTBOOKS