A small Hotel owner wish to computerized the management of hotel operations. You are asked to assist in the development of a database for the hotel. The database keeps data about ROOM, EMPLOYEE and FACILITY. From the discussion session with the hotel manager, you have identified the following information: • Three types of ROOMS offered by the hotel are single, double and deluxe room. Each room is identified by its unique number. • In general, there are two main types of the hotel jobs, GUEST SERVICES and ADMINISTRATIVE & SUPPORT. • HOTEL MANAGER, EVENT PLANNER and ACCOUNTANT are the administrative and support job positions in the hotel. • Types of employee falls under the guest services are RECEPTIONIST, HOUSEKEEPER, or KITCHEN STAFF. • Each RECEPTIONIST is identified with her/his name, employee number and years of experience. • The receptionists need to assign a HOUSEKEEPER to each room every morning or whenever it required before the room can be assigned to a guest to ensure the room is clean. • The same room may need to be cleaned several times on the same day, before it gets reassigned. • The date and the status need to be recorded for each cleaning assignment. • The KITCHEN STAFF works on the front lines of restaurant, cafeteria, and catering kitchens, interacting with cooks, waitstaff, bartenders, and sometimes customers. • The cleaning staff and the kitchen staff are also uniquely identified by their employee number. • The duties and responsibilities of a Receptionists is to receive guest at the front desk by greeting, welcoming, directing and announcing them appropriately, they are also require to allocate a unique room to each guest and specify one group of facilities which is accessible to the guest during his stay. • Guests are uniquely identified with their IC number but other necessary information are also recorded about the guests, including: name, phone numbers, arrival date, departure date, and credit card number. • Each FACILITY GROUP contains specific set of facilities, e.g. the bar or gym, in order to be used by the guests. • The arrival and departure dates of a guest will in turn determine the occupation of a specific room.
A small Hotel owner wish to computerized the management of hotel operations. You are asked to assist in the development of a database for the hotel. The database keeps data about ROOM, EMPLOYEE and FACILITY. From the discussion session with the hotel manager, you have identified the following information: • Three types of ROOMS offered by the hotel are single, double and deluxe room. Each room is identified by its unique number. • In general, there are two main types of the hotel jobs, GUEST SERVICES and ADMINISTRATIVE & SUPPORT. • HOTEL MANAGER, EVENT PLANNER and ACCOUNTANT are the administrative and support job positions in the hotel. • Types of employee falls under the guest services are RECEPTIONIST, HOUSEKEEPER, or KITCHEN STAFF. • Each RECEPTIONIST is identified with her/his name, employee number and years of experience. • The receptionists need to assign a HOUSEKEEPER to each room every morning or whenever it required before the room can be assigned to a guest to ensure the room is clean. • The same room may need to be cleaned several times on the same day, before it gets reassigned. • The date and the status need to be recorded for each cleaning assignment. • The KITCHEN STAFF works on the front lines of restaurant, cafeteria, and catering kitchens, interacting with cooks, waitstaff, bartenders, and sometimes customers. • The cleaning staff and the kitchen staff are also uniquely identified by their employee number. • The duties and responsibilities of a Receptionists is to receive guest at the front desk by greeting, welcoming, directing and announcing them appropriately, they are also require to allocate a unique room to each guest and specify one group of facilities which is accessible to the guest during his stay. • Guests are uniquely identified with their IC number but other necessary information are also recorded about the guests, including: name, phone numbers, arrival date, departure date, and credit card number. • Each FACILITY GROUP contains specific set of facilities, e.g. the bar or gym, in order to be used by the guests. • The arrival and departure dates of a guest will in turn determine the occupation of a specific room.
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...
Related questions
Question
A small Hotel owner wish to computerized the management of hotel operations. You are asked to assist in the development of a database for the hotel. The database keeps data about ROOM, EMPLOYEE and FACILITY. From the discussion session with the hotel manager, you have identified the following information:
• Three types of ROOMS offered by the hotel are single, double and deluxe room. Each room is identified by its unique number.
• In general, there are two main types of the hotel jobs, GUEST SERVICES and ADMINISTRATIVE & SUPPORT.
• HOTEL MANAGER, EVENT PLANNER and ACCOUNTANT are the administrative and support job positions in the hotel.
• Types of employee falls under the guest services are RECEPTIONIST, HOUSEKEEPER, or KITCHEN STAFF.
• Each RECEPTIONIST is identified with her/his name, employee number and years of experience.
• The receptionists need to assign a HOUSEKEEPER to each room every morning or whenever it required before the room can be assigned to a guest to ensure the room is clean.
• The same room may need to be cleaned several times on the same day, before it gets reassigned.
• The date and the status need to be recorded for each cleaning assignment.
• The KITCHEN STAFF works on the front lines of restaurant, cafeteria, and catering kitchens, interacting with cooks, waitstaff, bartenders, and sometimes customers.
• The cleaning staff and the kitchen staff are also uniquely identified by their employee number.
• The duties and responsibilities of a Receptionists is to receive guest at the front desk by greeting, welcoming, directing and announcing them appropriately, they are also require to allocate a unique room to each guest and specify one group of facilities which is accessible to the guest during his stay.
• Guests are uniquely identified with their IC number but other necessary information are also recorded about the guests, including: name, phone numbers, arrival date, departure date, and credit card number.
• Each FACILITY GROUP contains specific set of facilities, e.g. the bar or gym, in order to be used by the guests.
• The arrival and departure dates of a guest will in turn determine the occupation of a specific room.
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY