a$.$ Using the STUDENT table structure shown in Table Q$2,$ write the relational schema, draw its dependency diagram, and identify all dependencies $($including all transitive dependencies$).$

b$.$ Using the initial dependency diagram drawn in Question $2$a$,$ normalise the structure to meet the $3NF$ requirements to the greatest extent possible. If you believe that practical considerations dictate using a $2$NF structure, explain why your decision to retain $2NF$ is appropriate. If necessary, add or modify attributes to create appropriate determinants and to adhere to the naming conventions.

Table Q$2$: Sample STUDENT Records

$\backslash$table$[[$Attribute Name,Sample,Sample,Sample,Sample,Sample$],[$STU$\_$NUM,$211343,200128,199876,198648,223456],[$STU$\_$LNAME,Stephanos,Smith,Jones,Ortiz,Mckulski$],[$STU$\_$MAJOR,Accounting,Accounting,Marketing,Marketing,Statistics$],[$DEPT$\_$CODE,ACCT,ACCT,MKTG$,$MKTG$,$MATH$],[$DEPT$\_$NAME,Accounting,Accounting,Marketing,Marketing,Mathematics$],[$DEPT$\_$PHONE,$4356,4356,4378,4378,3420],[$COLLEGE$\_$NAME,Business,Business,Business,Business,$],[,$Admin,Admin,Admin,Admin,Sciences$],[$ADVISOR$\_$LNAME,Grastrand,Grastrand,Gentry,Tillery,Chen$],[$ADVISOR$\_$OFFICE,T$201,$T$201,$T$228,$T$356,$J$331],[$ADVISOR$\_$BLDG$,$Torre,Torre,Torre,Torre,Jones$],[$ADVISOR$\_$PHONE,$2115,2115,2123,2159,3209],[$STU$\_$GPA,$3\mathrm{.}87,2\mathrm{.}78,2\mathrm{.}31,3\mathrm{.}45,3\mathrm{.}58],[$STU$\_$HOURS,$75,45,117,113,87],[$Building$,$Building,Building,Building,Building,$],[$UG$1,$UG$2,$UG$3,$UG$3,$UG$1,]]$