Transform the Relation in Figure TB 5

question 144

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}$

---

Definitions:

Licensing

The act of giving official permission to an individual or organization to do something, especially to use intellectual property or conduct certain types of business activities.

Royalty

Royalty is a payment made to the owner of certain property rights, such as patents, copyrighted works, or natural resources, for the use of those rights.

Organic Chemicals

Compounds primarily made of carbon atoms bonded together, along with hydrogen, oxygen, and other elements, used in a wide array of industrial and consumer products.

Geocentric Staffing Model

The geocentric staffing model puts parent-country, host-country, and third-country nationals all in the same category, with the firm attempting to always hire the best person available for a position.