fix this EER diagram:

 

I have also attached the worded er diagram summary which can take a look to fix this EER Diagram:

Entity:

- Client

- Room

- Outdoor Instructor

- Massage Therapist

- Swimming Instructor

- Activity Supervisor

- Supplier

- Activity

 

Attribute:

- Client: Name, Address, Phone Number, Health Conditions

- Room: Room Number, Level, Adjoined Room

- Outdoor Instructor: ID, Name, Field of Expertise

- Massage Therapist: ID, Name, Qualification

- Swimming Instructor: ID, Name

- Activity Supervisor: ID, Name

- Supplier: Business Name, Contact Person, Contact Number, Biller Code

- Activity: Name, Description, Risk Level, Cost

 

Primary Keys:

- Client: Name

- Room: Room Number

- Outdoor Instructor: ID

- Massage Therapist: ID

- Swimming Instructor: ID

- Activity Supervisor: ID

- Supplier: Business Name

- Activity: Name

 

Relationships:

- Client to Room (1:1)

- Client to Activity (1:N)

- Room to Activity (1:N)

- Outdoor Instructor to Activity (M:N)

- Massage Therapist to Activity (M:N)

- Swimming Instructor to Activity (M:N)

- Activity Supervisor to Activity (M:N)

- Supplier to Activity (1:N)

 

Cardinalities:

- Client to Room (1:1)

- Client to Activity (1:N)

- Room to Activity (1:N)

- Outdoor Instructor to Activity (M:N)

- Massage Therapist to Activity (M:N)

- Swimming Instructor to Activity (M:N)

- Activity Supervisor to Activity (M:N)

- Supplier to Activity (1:N)

 

Participations:

- Client to Room (Mandatory)

- Client to Activity (Optional)

- Room to Activity (Optional)

- Outdoor Instructor to Activity (Optional)

- Massage Therapist to Activity (Optional)

- Swimming Instructor to Activity (Optional)

- Activity Supervisor to Activity (Optional)

- Supplier to Activity (Mandatory)

 

Specialisation/Generalisation:

- Room

  - Deluxe Cottage

  - Honeymoon Cottage

  - Deluxe Accommodation with Double Bed

  - Deluxe Accommodation with Single Bed

 

Completeness and Disjointedness Constraints:

- Client: Total

- Room: Partial (1 room must have 1 adjoined room)

- Outdoor Instructor: Total

- Massage Therapist: Total

- Swimming Instructor: Total

- Activity Supervisor: Total

- Supplier: Total

- Activity: Total

 

Union:

- Room: Deluxe Cottage + Honeymoon Cottage + Deluxe Accommodation with Double Bed + Deluxe Accommodation with Single Bed

Transcribed Image Text:

Phone No Address (Health_Condition Room No Level Adjoined Room) Deluxe Cottage Name Client M(0,1) Books M(1,1) Room M1,1) Cost Honeymoon cottage Name M(1,1) Choose Risk Level provides Description -M(0,M)- M(0,M) ID Deluxe Accommodation. with Single Bed Business Name) Activity Activity Supervisor M(1,M) provides Name M(1,1) Supplier Contact Person) Deluxe Accommodation with Double Bed Outdoor Instructor) ID Biller Code Massage Therapist Contact No Swimming Instructor Name Name Field ID Name Qualification ID Phone No Address (Health_Condition Room No Level Adjoined Room) Deluxe Cottage Name Client M(0,1) Books M(1,1) Room M1,1) Cost Honeymoon cottage Name M(1,1) Choose Risk Level provides Description -M(0,M)- M(0,M) ID Deluxe Accommodation. with Single Bed Business Name) Activity Activity Supervisor M(1,M) provides Name M(1,1) Supplier Contact Person) Deluxe Accommodation with Double Bed Outdoor Instructor) ID Biller Code Massage Therapist Contact No Swimming Instructor Name Name Field ID Name Qualification ID

Answer rating: 100% (QA)

To fix the provided EER Enhanced EntityRelationship diagram according to the given summary you should make the following corrections 1 Client to Room ... View the full answer