Constructing Entity Relationship Diagram

A gym database

You are asked to develop a preliminary ERD for a gym database. You discover the entity types that should be included as shown in the provided figure. During further discussions you discover the following:

The employees can be staff or trainers. The Employee type field is used to distinguish between the two, which takes the value S and T for staff and trainer respectively.

Each member can opt for one or more than one program.

The gym offers several programs. A program might not have been opted for by any member of the gym.

The gyms management wishes to track the payment details of the members. (Amount, Mode of Payment and Date of payment). Suggest how they can track this.

Construct an ER diagram to represent your findings from the above situation.

Discuss the followings with your group members when constructing an ER diagram

What are the cardinalities from the business rules and how can these be modelled on the ER diagram.

What can be the identifier for Program Opted entity is it composite or primary?

If payment information is also to be stored in this entity, which other attributes are you likely to add?