$1.$ Task #$1$ Normalization

In the lecture, we discussed normalization. The two datasets below are not normalized yet, so we should normalize the datasets into $3$NF tables. Show the normalization steps for each dataset using the format provided in the example.

Example$)$

$1$ NF:

PROJECT $($ProjectNum$,$ Proj$\_$Name, Start$\_$Date, Emp$\_$Num, Emp$\_$Name, Job$\_$Class$\_$Code, Job$\_$Class$\_$Desc$)$

$2$ NF:

PROJECT $($ProjectNum$,$ Proj$\_$Name, Start$\_$Date$)$

EMP $($Emp$\_$Num, Emp$\_$Name, Job$\_$Class$\_$Code, Job$\_$Class$\_$Desc, ProjectNum$)$

$3$ NF:

PROJECT $($ProjectNum$,$ Proj$\_$Name, Start$\_$Date$)$

EMP $($Emp$\_$Num, Emp$\_$Name, Job$\_$Class$\_$Code, ProjectNum$)$

JOB$\_$CLASS $($Job$\_$Class$\_$Code, Job$\_$Class$\_$Desc$)$

$**$ Bold and underlined fields are primary keys and italicized fields are foreign keys

Dataset #$1$

$($Stu$\_$Num, Stu$\_$Name, Stu$\_$Major$\_$Code, Stu$\_$Major$\_$Title, Dept$\_$Code, Dept$\_$Name, Dept$\_$Phone, College$\_$Code, College$\_$Name, Advisor$\_$Num, Advisor$\_$Name, Advisor$\_$Office, Advisor$\_$Phone, Stu$\_$Currnent$\_$Gpa$)$

$**$ In the table design, we want to show that departments belong to certain college $($rather than showing that students belong to certain college$).$