For each of the following EER diagrams from Chapter $3$:

I. Transfom$1$ the diagram into a relational schema that

shows referential integrity constraints

II$.$ For each relation, diagram the functiona l dependencies

Ill. If any of the relations a re not in $3$NF$,$ transform them

to $3$NFFIGURE $3-9$ Subtype discriminator $($overlap rule$)$