Question. Construct the Conceptual model $($ER$+$ EER$)$ for the Requirements Below $(20$ points$)$

Scenario:

A luxury hotel chain wants to manage and track bookings, services offered, and staff involvement across multiple hotel locations. The goal is to represent key entities $($customers$,$ hotel staff, services, and bookings$)$ and their relationships, with two types of relationships: one for services booked $($offered$)$ and another for services completed $($performed$).$

Business Rules:

$*$ Acustomer can book many services across mutple hotes and

many staff members can perform these services.

$*$ There are two types of relationships between customers, staff, and services:

$1.1.$ Booked Services: To show services requested by the

customer.

$2.$ Completed Services: To track services performed by staff after booking.

$*$ Each hotel can offer multiple services and employ various types of staff.

Entities:

$1.$ Hotel Staff: There are two types of staff$-$Concierge and Maintenance Staff.

$*$ Concierge: Assists guests with services such as reservations, local recommendations, and event planning.

Attributes: Employee ID $($identifier$),$ Name, Address $($composed of Street, City, State, and Zip Code$),$ Phone, Date of Birth, Years of Experience, and Specializations.

$*$ Maintenance Staff: Ensures the proper functioning of the hotel facilities and provides technical support when required.

Attributes: Employee ID $($identifer$),$ Name, Address $($composed of Street, City, State, and Zip Codel, Phone, Date of Birth, Technical Skills, Certifications, and Years of Experience.

$2.$ Customer: Represents guests who book services at the hotels.

Attributes: Customer ID $($identifier$),$ Name, Address $($composed of Street, City, State, and Zip Code$),$ Phone, Email, and Loyalty Status $($e$.$g$,$ Gold, Silver, or Regular$).$

$3.$ Hotel Location: A customer can book services at multiple hotel locations.

Attributes: Hotel ID identifer$),$ Location ID $($unique to each hotel, Address $($composed of Street, City, State, and Zip Code$),$ Phone, and Number of Rooms.

$4.$ Service: Represents luxury services offered by the hotel chain.

Attributes: Service ID $($identifier$),$ Description, Service Cost, Service Type $($e$.,$ Spa, Dining, Transportation$),$ and Staff Required.

$5.$ Booking Details: Captures information related to service bookings.

Attributes: Booking ID $($identifer$),$ Date of Booking, Customer, Concierge, Service, Hotel Location, and Total Amount.

$6.$ Service Completion: Captures services performed by staff after booking.

Attributes: Service Completion ID $($identifer$),$ Date of

Completion, Maintenance Staf, Service, HotelLocation, and

Final Amount Charged.