Solved

Transform the Relation in Figure TB 5

Question 173

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
 Student  Number  Student  Name  Course  Code  Course  Course Title  Professor  Grade 53425 John Simms 10534 AC 313 Acoounting Systems  Kellogg  A 53425 Jotn Simms 12402 EC 413  Microeconomics  Roberts  B 42988 Patt Ray 12467 MK 313  Prin. of Marketing  Lane  C 42988 Patt Ray 10534 AC 313  Acoounting Systems  Kellogg  B 42988 Patt Ray 32534 LS 113 Landscape Design  Miller  B 15342 Ron Adams 12400 EC 413  Microeconomics  Roberts  A 15342 Ron Adams 30536 GG 113 Gedogy  Harris  C \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}

Correct Answer:

verifed

Verified

\[\begin{array}{l}
Student\\
\begin{arra...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents