Question: Table 1 - Courses Taken Table Class _ ID ClassName ClassCreditHours StudentID StudentName Grade C 1 1 1 Math 1 4 S 1 1 1
Table Courses Taken Table
ClassID ClassName ClassCreditHours StudentID StudentName Grade
C Math S Jim Smith Pass
C Math S Sally Smith Pass
C English S Megan Moore Pass
C History S Patrick Clark Fail
C History S Lisa Clark Pass
C History S Tom Clark Pass
C History S Jim Smith Pass
C History S Sally Smith Fail
C History S Bo Lewis Pass
Is the Courses Taken table above in st normal form? If not, what changes are needed to convert it to NF
Is the Courses Taken table in nd normal form? If not, describe the changes needed to comply with the requirements for NF Be specific.
Lastly, is the Courses Taken table in NF If not, in addition to the changes you have described in questions & what additional changes would be needed to assure compliance with NF Be specific.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
