Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 Database

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Expert Performance Indexing In SQL Server

Authors: Jason Strate, Grant Fritchey

2nd Edition

1484211189, 9781484211182

More Books

Students also viewed these Databases questions