Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please submit it in a way that looks like word format STUDENT CLASSES ASSIGNMENT DESCRIPTION: Using your knowledge of a college environment, convert the following
Please submit it in a way that looks like word format
STUDENT CLASSES 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, 2NF and 3NF during the conversion. List the functional dependencies. Please complete the question in electronic format such as Word or PDF so that they can be uploaded to Canvas TABLE STUDENT (STUNUMB STUNAME, NUMCRED, ADVNUMB, ADVNAME, CRSENUMB CRSEDESC, GRADE) STUNUMB STUNAME NUMCREDADVNUMB ADVNAME CRSENUMB CRSEDESC GRADE 800342124 Joe Beck 3 800076565 Roy Cone | ?TCS3 160 | Database B ITCS3166 Networks A ITCS4102 Langua 800217341 Ann Alda4 800025414 lan Jones ITCS1 1213 Java TCS1213L Java Lab A MATH1241 Calculus C LBST1104 Films 800666154 Sue Dane 3 800001136Eva Thick ITCS2215 AlgorithmsB MATH1242 Calculus D ITCS3160 Database A 800134666 Bob Wal3 800025414 lan Jones MATH1242 Calculus D ITCS3166 Networks ITCS4102 Languages C ITCS3160 Database 800189871 Ava Best 4 800001136 Eva Thick ITCS1 1213 Java ITCS1213L Java Lab PSYC1101 Psychology C PSYC1101L Psych Lab C LBST1104 Films 800314321 Will Sneed 3 800001136 Eva Thick MATH1242 Calculus A ITCS3166 Networks ITCS4102Languages ITCS3160 Database STUDENT CLASSES 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, 2NF and 3NF during the conversion. List the functional dependencies. Please complete the question in electronic format such as Word or PDF so that they can be uploaded to Canvas TABLE STUDENT (STUNUMB STUNAME, NUMCRED, ADVNUMB, ADVNAME, CRSENUMB CRSEDESC, GRADE) STUNUMB STUNAME NUMCREDADVNUMB ADVNAME CRSENUMB CRSEDESC GRADE 800342124 Joe Beck 3 800076565 Roy Cone | ?TCS3 160 | Database B ITCS3166 Networks A ITCS4102 Langua 800217341 Ann Alda4 800025414 lan Jones ITCS1 1213 Java TCS1213L Java Lab A MATH1241 Calculus C LBST1104 Films 800666154 Sue Dane 3 800001136Eva Thick ITCS2215 AlgorithmsB MATH1242 Calculus D ITCS3160 Database A 800134666 Bob Wal3 800025414 lan Jones MATH1242 Calculus D ITCS3166 Networks ITCS4102 Languages C ITCS3160 Database 800189871 Ava Best 4 800001136 Eva Thick ITCS1 1213 Java ITCS1213L Java Lab PSYC1101 Psychology C PSYC1101L Psych Lab C LBST1104 Films 800314321 Will Sneed 3 800001136 Eva Thick MATH1242 Calculus A ITCS3166 Networks ITCS4102Languages ITCS3160 DatabaseStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started