Question: 2. Given the following table with sample data Table Name: StudentRecord Attribute Name STU NUM STU LNAME STU MAJOR DEPT CODE DEPT NAME DEPT PHONE
2. Given the following table with sample data Table Name: StudentRecord Attribute Name STU NUM STU LNAME STU MAJOR DEPT CODE DEPT NAME DEPT PHONE COLLEGE NAME Business AdminBusiness AdminBusiness Admin ADVISOR LNAME Grastrand ADVISOR OFFICE T201 ADVISOR_BLDG Torre Building Torre Building ADVISOR PHONE 2115 STU_GPA STU HOURS STU CLASS Sample Value 211343 Stephanos Accounting ACCT Accounting 4356 Sample Value 200128 Smith Accounting ACCT Accounting 4356 Sample Value 199876 Jones Marketing MKTG Marketing 4378 Sample Value 199876 Ortiz Marketing MKTG Marketing 4378 Sample Value 223456 McKulski Statistics MATH Mathematics 3420 Business Admin Arts & Sciences Grastrand Gentry T228 Torre Building 2123 2.31 Tillery T356 Torre Building 2159 3.45 113 Senior Chen J331 Jones Building 3209 3.58 87 Junior T201 2115 2.78 45 Sophomore 3.87 75 unior Senior 1. Identify all the partial dependencies and transitive dependencies 2. Convert the table created into second normal form 3. Convert the table(s) created in step 2 into third normal form 2. Given the following table with sample data Table Name: StudentRecord Attribute Name STU NUM STU LNAME STU MAJOR DEPT CODE DEPT NAME DEPT PHONE COLLEGE NAME Business AdminBusiness AdminBusiness Admin ADVISOR LNAME Grastrand ADVISOR OFFICE T201 ADVISOR_BLDG Torre Building Torre Building ADVISOR PHONE 2115 STU_GPA STU HOURS STU CLASS Sample Value 211343 Stephanos Accounting ACCT Accounting 4356 Sample Value 200128 Smith Accounting ACCT Accounting 4356 Sample Value 199876 Jones Marketing MKTG Marketing 4378 Sample Value 199876 Ortiz Marketing MKTG Marketing 4378 Sample Value 223456 McKulski Statistics MATH Mathematics 3420 Business Admin Arts & Sciences Grastrand Gentry T228 Torre Building 2123 2.31 Tillery T356 Torre Building 2159 3.45 113 Senior Chen J331 Jones Building 3209 3.58 87 Junior T201 2115 2.78 45 Sophomore 3.87 75 unior Senior 1. Identify all the partial dependencies and transitive dependencies 2. Convert the table created into second normal form 3. Convert the table(s) created in step 2 into third normal form
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help