Answered step by step
Verified Expert Solution
Question
1 Approved Answer
use sql please STUDENT CLASSES ASSIGNMENT DESCRIPTION: Using your knowledge of a college environment, convert the following table to an equivalent collection of tables in
use sql please
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 NUMCRED ADVNUMB ADVNAME CRSENUMB CRSEDESC GRADE 800342124 Joe Beck 3 800076565 Roy Cone ITCS3160 Database B 3 ITCS3166 Networks 3 ITCS4102 Languages B 800217341 Ann Alda 4 800025414 Ian Jones ITCS1213 Java A 0 ITCS1213L Java Lab A 3 MATH1241 Calculus 3 LBST1104 Films 800666154 Sue Dane 3 800001136 Eva Thick ITCS2215 Algorithms B 3 MATH 1242 Calculus 11 D 3 ITCS3160 Database A 800134666 Bob Wall 800025414 Ian Jones MATH1242 Calculus II D ITCS3166 Networks B ITCS4102 Languages 3 ITCS3160 Database B 800189871 Ava Best 4 800001136 Eva Thick ITCS1213 Java A ITCS1213L Java Lab A 3 PSYC1101 Psychology PSYC1101L Psych Lab 3 LBST1104 Films B 800314321 Will Sneed 3 800001136 Eva Thick MATH1242 Calculus II A 3 ITCS3166 Networks A 3 ITCS4102 Languages 3 ITCS3160 Database A REQUIREMENTS: Each student must work independently on this assignment. No group work is allowed. As stated above, complete the assignment electronic format. Submit completed work into Canvas. Take a screenshot of the submission verification in the event you need proof of submissionStep 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