Description
Need this lab done, you will need Draw.IO, i have the link for it
Unformatted Attachment Preview
Lab2 EERD
Please draw an Enhanced Entity Relationship diagram.
Company Overview: TU hotel is a singular, mid-sized hotel company with over a
hundred different workers employed. TU hotel has eight different departments:
front desk, management, IT, maintenance, housekeeping, event planning,
accounting and food and beverage. The fundamental mission of TU hotel is to
provide a comfortable and welcoming environment for guests and to offer a
range of services and amenities that meet their needs and expectations. We
have several booking methods, to ensure that needs are always met regardless
of the age or ethnicity of the guest. One being online booking, through our
direct website or third-party travel agencies. Phone reservation, in which the
guest would call us directly, is particularly useful for guests who have specific
requests. Lastly deposit reservations in which guests are also able to make
deposits for reservations that are booked months prior rather than paying the full
balance ahead of time. TU is dedicated to ensuring that every guest’s needs are
met, regardless of their background or preferences. The company’s commitment
to providing a comfortable and welcoming environment aligns with its mission.
The diverse booking methods cater to a wide range of guest preferences and
ensure a seamless and accommodating booking experience.
Guests may be either a regular guest or a valued guest, but not at the same
time. For the valued guest,
he/she can get a discount rate based on a
Valued_Program_No and ApprovedDate.
Attributes: GuestID (Primary Key), FirstName, LastName, Email, Phone, Address,
Age, Gender.
Relationships:
·
·
A guest may make multiple reservations.
A guest may request multiple services.
Reservation
Attributes: ReservationID (Primary Key), CheckInDate, CheckOutDate, TotalCost,
Status
Relationships:
·
A reservation must be associated with exactly one guest.
·
Each reservation must have at least one room.
Room
Attributes: RoomNumber (Primary Key), RoomType, PricePerNight, Occupancy,
Availability
Relationships:
·
More than one room can be part of one reservation.
Employees must be either a part_time or a full- time employee and later a
full-time employee can be converted into a part-time employee. The hotel will
keep a record of hourly rate and the number of hours for the part-time
employee and salary and rank for full time employees.
Attributes: EmployeeID (Primary Key), FirstName, LastName, JobTitle, Shift,
ContactInfo, StartDate
Relationships:
·
Each employee must be assigned to exactly one department.
·
One or more employees must be assigned to one or more services.
Department
Attributes: DepartmentID (Primary Key), DepartmentType
Relationships:
·
A department can have one or many employees
·
A department can plan one or more services.
Services
Attributes: SrvID (Primary Key), EventName, Date, Description, Budget
Relationships:
·
Multiple services can be requested by guests.
·
Each service must be coordinated by exactly one department.
Purchase answer to see full
attachment
