Question #$3(20-$point bonus question$).$

We have a STUDENT table in $1$NF$.$ The combination of Student$\_$ID and Course$\_$ID is the composite primary key

STUDENT $($Student ID$,$ Course ID$,$ Student$\_$Name, Course$\_$Description, Course$\_$Grade, Advisor$\_$ID$,$ Advisor$\_$Name, Instructor$\_$ID$,$ Instructor$\_$Name$)$

Specifically, the functional denpendencies are:

Student$\_$ID $$ Student$\_$Name, Advisor$\_$ID$,$ Advisor$\_$Name

Course$\_$ID $$ Course$\_$Description, Instructor$\_$ID$,$ Instructor$\_$Name

Student$\_$ID$,$ Course$\_$ID $$ Course$\_$Grade

Advisor$\_$ID $$ Advisor$\_$Name

Instructor$\_$ID $$ Instructor$\_$Name

Please convert this STUDENT table in $1$NF to $3$NF $($Please list all the tables in $3$NF$)$ Draw a diagram.