Question$1$: Consider the Entity Relational $($ER$)$ schema of relation R$=($A$,$ B$,$ C$,$ D$,$ E$($E$1,$ E$2))$; knowing that there are the following functional dependencies $($f$.$d$.)$:

fd$1$: $\backslash (\backslash \{$A$,$ C$\backslash \}\backslash$rightarrow$\backslash \{$B$,$ E$\backslash \}\backslash )$

$1.$ Can you guess the primary key attribute$($s$)?$ Justify your answer

$2.$ Is R in $1$NF$?$ If "yes" why? If not modify R so as to put it in $\backslash (1$ N F $\backslash ).$ Let us call R$1$ the result of this

$3.$ Is R$1$ in $2$NF$?$ If "yes" why? If not modify R$1$ so as to put it in $2$NF$.$ Let us call R$2$ the result of this

$4.$ Is R$2$ in $3$NF$?$ If "yes" why? If not modify R$3$ so as to put it in $3$NF

Question$2$: Knowing the relational schema of the Company database:

$1.$ Write a relational algebra query to derive the new relation:

EMP$\_$DEP$=($ENAME$,\backslash (\backslash$underline$\{\backslash$text $\{$ SSN $\}\}\backslash )$ BDATA, ADDRESS, DNAME, DMGRSNN$)$

$2.$ Populate your new relation with at least $5$ entries,

$3.$ Discuss insertion, deletion and modification anomalies.