Design a Relational Model $($logical database$)$in $3$NF according to the problem description.

Details are provided in the assignment item Project Task$2.$

Project Task$2$: Suppose the ER diagram provided here Download here$($attached diagram$)$Be informed is used for the project. In task $2,$you need to complete the following two parts.

$1.$Convert the ER diagram directly into a relational model, including the functional dependencies.

$2.$Normalize the relational model to Third Normal Form $(3$NF$).$There is no need to show the functional dependencies in this part.

In other words, you need to submit two relational models for $(1)$and $(2)$above$.$ However, if your relational model in $(1)$is already in $3$NF$,$then you do not need to provide a second relational model in $(2),$but give an explanation of why it is already in $3$NF instead.

Please note that this ER diagram is NOT a good solution. It is intended solely for Task $2$purposes$.$

Below are some additional notes:

If your relational model in Part $1$of Task $2$is already in $3$NF$,$then you may not need to provide a second relational model in Part $2$of task $2,$but give an explanation of why it is already in $3$NF instead.

If your relational model in Part $1$of Task $2$is not in $3$NF$,$then you need to normalize it to $3$NF for Part $2$of Task $2.$The normalization from Part $1$to Part $2$are self$-$explanatory, so no further explanation is needed.