Consider the following two tables:

$($Department#$,$ dept$-$name, location, $[$professor#$])$

$($Professor#$,$ prof$-$name, address, phone$)$

Professor# is a foreign key in the department table and links the two tables together.

Based on the rules of normalization, answer Part A and B below.

A$)$ What is wrong with these relations $($i$.$e$.,$ what specific problems will be caused$)?$

B$)$ How do you propose to fix the tables in order to adhere to the rules of normalization?

C$)$ Provide a brief explanation for $1$NF$,2$NF$,$ and $3$NF$.$