Assignment $2$: Relational Modeling

Requirements:

$1.$ Your tasks for this assignment are to translate the ER diagram below into a relational schema in $3$NF$.$

$2.$ For each relation, clearly specify $($a$)$ the name of the relation, $($b$)$ attributes for the relation, $($c$)$ denote the primary key, if any, using bold font and solid underline, and $($d$)$ denote any foreign key using dotted underline. If you cannot create the dotted underline, you may instead use a $($fk$)$ subscript. In other words, the following two styles of solutions are both acceptable:

$$ RELATION$\_$NAME $($attribute$1,$ attribute $2,$ attribute$3,...)$

$$ RELATION$\_$NAME $($attribute$1,$ attribute $2,$ attribute$3($fk$),...)$

$3.$ List all the functional dependencies for each relation and verify that it is in $3$NF$.$ To specify a functional dependency for a relation, use a format similar the following:

$$ RELATION$\_$NAME $($attribute$1,$ attribute $2,$ attribute$3,...)$

$$ attribute$1$ attribute$2,$ attribute$3$

$$ This relation is in $3$NF because $...$