Transform following ER diagram into $3NF$ relations. In your relation, please specify the primary key, foreign keys $($if have$),$ and all dependencies. Draw the relations.

The following table shows a relation called GRADE REPORT for a university: Your assignment is as follows:

$\backslash$table$[[$StudentiD$,$StudentName,CampusAddress,Major,CourselD,CourseTitle,$\backslash$table$[[$Instructor$],[$Name$]],\backslash$table$[[$Instructor$],[$Location$]],$Grade$],[168300458,$Williams,$208$ Brooks,K$,15350,$Oatabasa Mgt$,$Codd,B $104,$A$],[168300458,$Williams,$208$ Brooks,$15,15\mathrm{.}465,$Systems Analy;is$,$Parsons,B $317,$B$],[543291073,$Baker,to$4$ Phillips,Arctg,is $350,$Datibase Mat,Codd,B $104,$c$],[543291073,$Baker,$104$ Prillips.,Accig,Acct$201,$Fund Accig,Miller,$4310,$B$],[543291073,$Baker,$104$ Ptillips,Acctg,Mkgl $300,$Intro Mkig,Rennett,B $212,$A$]]$

$4\mathrm{.}1.$ Draw a relational schema and diagram the functional dependencies in the relation.

$4\mathrm{.}2.$ In what normal form is this relation?

$4\mathrm{.}3.$ Decompose GRADE REPORT into a set of $3PF$ relations, and show the referential integrity constraints among relations.