Transform the Relation in Figure TB 5

Essay

Transform the relation in Figure TB 5.3 to second normal form (2NF). Label each new relation with a name that describes the attributes.
Courses
$\begin{array}{|c|l|l|l|l|l|c|}\hline\begin{array}{c}\text { Student } \\\text { Number }\end{array} & {\begin{array}{c}\text { Student } \\\text { Name }\end{array}} & \begin{array}{c}\text { Course } \\\text { Code }\end{array} & {\text { Course }} & {\text { Course Title }} & \text { Professor } & \text { Grade } \\\hline 53425 & \text { John Simms } & 10534 & \text { AC } 313 & \text { Acoounting Systems } & \text { Kellogg } & \text { A } \\53425 & \text { Jotn Simms } & 12402 & \text { EC 413 } & \text { Microeconomics } & \text { Roberts } & \text { B } \\42988 & \text { Patt Ray } & 12467 & \text { MK 313 } & \text { Prin. of Marketing } & \text { Lane } & \text { C } \\42988 & \text { Patt Ray } & 10534 & \text { AC 313 } & \text { Acoounting Systems } & \text { Kellogg } & \text { B } \\42988 & \text { Patt Ray } & 32534 & \text { LS } 113 & \text { Landscape Design } & \text { Miller } & \text { B } \\15342 & \text { Ron Adams } & 12400 & \text { EC 413 } & \text { Microeconomics } & \text { Roberts } & \text { A } \\15342 & \text { Ron Adams } & 30536 & \text { GG } 113 & \text { Gedogy } & \text { Harris } & \text { C }\\\hline\end{array}$