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:

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

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

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

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

Please convert this STUDENT table in $1$NF to $3$NF$.$ You must use ERDPlus to create the relational schema. Make sure you use ERDplus