Make an entity-relationship diagram ERD using Chen notation the case

Make sure identify entity sets, relationship sets, all attributes, and primary keys;

And identify connectivities for relationship sets; identify overlapping or disjoint constraints, if there is a specialization or generalization hierarchy.

Case

1. All- inclusive PK resort located on an island in the pacific Ocean offers packages for guests around the world. The resort management works with several tour operators distributing the resorts packages. Each tour operator is described by its ID, name of the company and contact phone. A tour operator may work with one or more airlines to bring tourists to the resort. An airline is described by its name, phone, and website. Each tour operator has representatives at the resort who arrange guest transportation, additional excursions, and deal with guests concerns. A representative is described by their ID, name, and phone number. Tour operators representatives are assigned to take care of several guests for the entire stay of the guests. It accommodates guests in 40 3- and 4-storey buildings. Some of the buildings face the ocean. Buildings are numbered from 1 to 40 and are described by their number, category (3- or 4-storey), and view (ocean, forest, or other buildings). Each building contains from 5 to 10 rooms. Rooms are numbered from 1 to the maximal number of rooms in the building, and are described by the number of beds in the room and a category like standard, executive, etc. All guests are represnt by GID, name, home address. All guests are classified into primary and standrad. Only an adult person can be a principal guest. It is important to record a status for each regular guest. The status indicates whether the guest is an adult, child or teenager. Primary guests credit card number is required. A room is reserved for a primary guest, and up to two regular guests are allowed to share the room along with the person who booked the room. Guest accommodation in the resort must be recorded in the database. A primary guest is responsible for all charges related to the room. The charges can be associated with the services not included in the package or damages made to the resort by the guests.

Available services are described by service ID, title, and an associated fee. Some services require reservation. The reservation is associated with the room. It is necessary to record the requested service, guest requested the service, room which account will be billed, and the date of the service. The charges must be paid by the principal guest before or at check-out.

Food is served at four restaurants. A restaurant is described by its ID, name, type, e.g., buffet or aya carte, and the theme, e.g., Italian, etc. Every guest who comes to a restaurant must be recorded. It is essential to know, the restaurant, the guest, date and type of meal the guest received, like breakfast

The resort employees are cooks, waiters, and workers. All employees are described by employee ID, name, and address. A cook has assigned category. Knowledge of foreign language is required for a waiter. A worker is described by their specialization. There are few managers in each group of employees. Regular employees receive their assignments and report to the managers. Some managers must report to other manager, who reports to the resort Director. Each cook works in a specific restaurant. Each restaurant may have several cooks. Waiters may work in different restaurants including the Buffet according to the schedule.