Convert the following table into first normal form, second normal form and third
ID: 3691516 • Letter: C
Question
Convert the following table into first normal form, second normal form and third normal form:
TABLE STUDENT CRSEDESC, GRADE) NUMB STUNAME NUMCRED, ADVNUMB, ADVNAME, CRSENUMB STUNUMB STUNAME NUMCRED ADVNUMB ADVNAME CRSENUMB CRSEDESC GRADE 800342124 Joe Beck3 800076565 Roy Cone ITCS3160 Database B TCS3166 Networks A ITCS4102 Languages B 800217341 Ann Alda4 800025414 lan JonesITCS1213 Java ITCS1213L Java Lab A MATH1241 CalculusI C LBST1104 Films 800666154 Sue Dane3 800001136 Eva Thick ITCS2215 Algorithms B MATH1242 Calculus I D ITCS3160 DatabaseA 800025414 lan JonesMATH1242 Calculus D ITCS3166 NetworksB ITCS4102Languages C ITCS3160 Database B 800134666 Bob Wall3 800189871 Ava Best4 800001136 Eva ThickITCS1213 Java ITCS1213L Java Lab A PSYC1101 PsychologyC PSYC1101L Psych Lab C LBST1104 Films 800314321 Will Sneed3 800001136 Eva ThickMATH1242 Calculus A Networks A TCS4102 Languages A ITCS3160DatabaseA ITCS3166 Networks AExplanation / Answer
The normalized table format will have the structure :
i) STUDENT (stunumb,stuname,numcred,advnumb,crsenumb)
ii) ADV(advnumb,advname
iii) COURSE (crsenumb,crsedesc)
iv) STUDENT_GRADE(stunumb,crsenumb,grade)