Suppose you need to develop a data model to structure data about staff and their

activities in a dermatology clinic, and potentially other processes and activities in the

clinic. There are different types of staff $($e$.$g$.$ medical assistants, doctors, nurse

practitioners$)$ who work with different types of patients and in different procedures

$($e$.$g$.$ cancer treatment, surgery, diagnosis, education$).$ We need to make sure to record

how many hours they are working with distinct patients and in specific activities.

Task: Propose an ER diagram to keep track of this information.

Requirements: Your ER diagram should address entities and attributes listed in the

description, but can also propose others that are not immediately apparent. You will

need: $$

At least $4$ entities, with least $4$ attributes $($on average$)$ per entity.

At least $2$ relationships, with minimum and maximum cardinality.

Any many$-$to$-$many relationship needs to be broken down.

PK and FK need to be identified.

Create a separate table that lists all the attributes, and identify the potential "data

type" for each attribute. The data type should be one of the following:

character $--$ any text or number

integer $--$ any integer value

decimal $--$ any integer or decimal value

binary $--$ true or false $/$ yes or no $/1$ or $0$ only

date $--$ any day, month, year date

Include a paragraph to explain your rationale.