ASSIGNMENT DESCRIPTION: Using your knowledge of a college environment, convert the following table to an equivalent collection of tables in 3NF (third normal form). Show the tables in 1NF and in 2NF during the conversion. Please complete the question in electronic format such as Word or PDF so that they can be uploaded to Moodle 2. TABLE: STUDENT (STUNUMB, STUNAME, NUMCRED, ADVNUMB, ADVNAME, CRSENUMB, CRSEDESC, GRADE) 3 STUNUMB STUNAME NUMCRED ADVNUMB ADVNAME CRSENUMB 800342124 Joe Beck CRSEDESC | GRADE 800076565 Roy Cone ITCS3160 3 ITCS3166 Database Networks B A 3 ITCS4102 800217341 Ann Alda 4 800025414 lan Jones ITCS1213 0 3 3 800666154 Sue Dane 3 800001136 Eva Thick ITCS1213L MATH1241 LBST1104 ITCS2215 Languages Java Java Lab B A Calculus I Films C A Algorithms B 3 MATH1242 Calculus II 3 ITCS3160 Database A 800134666 Bob Wall 3 800025414 lan Jones MATH1242 Calculus II D 3 ITCS3166 Networks 3 ITCS4102 Languages C 3 ITCS3160 Database 800189871 Ava Best 4 800001136 Eva Thick ITCS1213 Java 0 1 3 800314321 Will Sneed 3 800001136 Eva Thick 3 ITCS1213L PSYC1101 PSYC1101L LBST1104 MATH1242 ITCS3166 Java Lab A Psychology Psych Lab Films B Calculus II Networks A ITCS4102 Languages ITCS3160 Database REQUIREMENTS: ⚫ Each student must work independently on this assignment. No group work is allowed. The total point value of the assignment is 20 points As stated above, complete the assignment electronic format. Submit completed work into Moodle2. ⚫ Take a screenshot of the submission verification in the event you need proof of submission.