Need help fixing the ERR diagram attached. From the following feedback:

$1-$ No subtypes and No subtype attributes

$2-$ No completeness constraints rules applied.

$3-$ No disjointness constraints rules applied.

$4-$ No discriminator attribute created.

$5-$ Please follow Lab $1$ feedback.

$6-$ Also follow Lab $2$ directions.

Prior Requirements:

Need help updating the following ER Diagram. With the following requirements:

We consider Elijay Community Hospital employs both full

$-$

time and part

$-$

time staff for this lab.

There are also two types of patients at the hospital: inpatients and outpatients.

$1$

$.$

$$Make sure you apply the feedback from Lab

$1$

$$to your E

$/$

R diagram from Lab

$1$

$.$

$$

$2$njkhh and

$.$

$$Please complete lab

$1$

$$with the extended E

$/$

R diagram diagram

$($

EER diagram

$)$

$,$

$$considering Ellijay Community Hospital hires both full

$-$

time and part

$-$

time staff. There are also two types of patients at the hospital: inpatients and outpatients.

Feedback:

$-$

$$There is a many

$-$

to

$-$

many relationship between the Patient and Personnel entities.

$3$

$-$

$$There is a one

$-$

to

$-$

many relationship between Department and Personnel

$4$

$-$

$$The phone attribute of the patient entity is a multi

$-$

valued attribute. The double oval is a notation for it

$.$

$5$

$-$

$$The email attribute for Personnel Entity is also a multi

$-$

valued attribute. The double oval is used for it

$.$

$6$

$-$

$$Name and Address are composite attributes. Name

$($

last

$\_$

name, first

$\_$

name

$)$

$,$

$$Address

$($

street

$,$

$$city$,$ state, zip code

$)$

$.$

Current Updated Requirements:

$-$ Normalize the ER$/$EER diagram create a Normalized ER $($NER$)$ diagram.

To normalize the ER diagram, follow these instructions:

$$ What we did so far is ER$/$EER diagrams. In order to do ER$,$ our only concern is to capture right

entities with right attributes and right relationships between entities. Also we like to figure out

the general cardinality of relations.

$$ After we are done with ER$/$EER$,$ it is time to do some normalization. We can break the process

of normalization into two steps. First step is to normalize attributes, and second step is to

normalize relationships between entities.

NER Step $1$:

$$ Attribute Normalization is the process of turning compound attributes and multivalued

attributes into entities and establish a relationship between these new entities and the base

entity.

Use only $1$st normal form $(1$NF$)$ along with associative entity.

Feedback and new requirements need to be addressed.