Question: 2 . Normalize the following table up to 3 NF . Show all results after a . ) ( 1 N F )

2. Normalize the following table up to 3NF. Show all results after
a.)\(1 N F \)
b.)2 NF
c.)3 NF
State the keys in each case
\begin{tabular}{|c|c|c|c|c|c|}
\hline StudentID & Name & DOB & Subject & Grade & SubjectCode \\
\hline 123 & Adrian Whyte & \(27/7/77\) & Info Tech & 78 & IT \\
& & & Mathematics & 95 & MT \\
& & & English & 87 & En \\
\hline 145 & Patrice Kerr & \multirow{2}{*}{\(8/2/84\)} & Physics & 88 & Ph \\
& & & Mathematics & 65 & MT \\
& & & Spanish & 78 & SP \\
\hline 150 & Damion Kelly & \(3/4/65\) & Info Tech & 50 & IT \\
& & & Mathematics & 80 & MT \\
& & & English & 90 & En \\
\hline
\end{tabular}
2 . Normalize the following table up to 3 NF .

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!