Part $2$: Normalization $(60$ points$)$

$2\mathrm{.}1)$ For each of the relations below, specify in which normal form they are. Give a detailed explanation as to

why including any functional dependencies necessary to prove $(1)$ they are in a given form and $(2)$ they are not

in the next form. That is$,$ functional dependencies are not required to prove in$/$not in $0$ NF and in$/$not in $1$ NF $,$ but

they are for in$/$not in $2$ NF and in$/$not in $3$ NF $.$ Also, if the sample data suggests an attribute is a determinant, then

it is; you do not need to prove it logically$.$

$2\mathrm{.}1\mathrm{.}1)(10$ points$)$

The relation is in $1$ NF

Why?

The relation is in $1$NF because there is partial dependency

$2\mathrm{.}1\mathrm{.}2)(10$ points$)$