DRAW an enhance entity relationship diagram . Please show all the: • entities, attributes, primary keys, relationships and cardinalities • Identify the strong and weak entities • Indicate the identifying relationship in your EERD • Identify the total participation • Identify the types of generalizations/specializations represented in your EER diagram • Identify Multi-valued in your design
A small Hotel owner wish to computerized the management of hotel operations. You are asked to assist in the development of a
• 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.
Q1. DRAW an enhance entity relationship diagram .
Please show all the:
• entities, attributes, primary keys, relationships and cardinalities
• Identify the strong and weak entities
• Indicate the identifying relationship in your EERD
• Identify the total participation
• Identify the types of generalizations/specializations represented in your EER diagram
• Identify Multi-valued in your design
DRAW ONE EERD using Draw.io or HANDWRITTEN
IF
IF AI GENERATED ANSWER I'LL DISLIKE AND REPORT
IF AI GENERATED ANSWER I'LL DISLIKE AND REPORT
IF AI GENERATED ANSWER I'LL DISLIKE AND REPORT
Step by step
Solved in 3 steps with 1 images