2. Given the following table with sample data: Table Name: Student Record Attribute Name Sample Value...

 

Transcribed Image Text:

2. Given the following table with sample data: Table Name: Student Record Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value STU_NUM 211343 200128 199876 199876 223456 STU_LNAME Stephanos Smith Jones Ortiz McKulski STU_MAJOR DEPT_CODE Accounting Accounting Marketing Marketing Statistics ACCT ACCT MKTG MKTG MATH DEPT_NAME Accounting Accounting Marketing Marketing DEPT PHONE 4356 4356 4378 4378 Mathematics 3420 COLLEGE_NAME Business Admin ADVISOR_LNAME Grastrand Business Admin Business Admin Business Admin Arts & Sciences Grastrand ADVISOR OFFICE T201 T201 Gentry T228 Tillery T356 Chen J331 ADVISOR BLDG Torre Building Torre Building Torre Building Torre Building Jones Building ADVISOR PHONE 2115 2115 2123 2159 3209 STU GPA STU_HOURS 3.87 2.78 2.31 3.45 3.58 75 45 117 113 87 STU_CLASS Junior Sophomore Senior Senior Junior 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: Student Record Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value STU_NUM 211343 200128 199876 199876 223456 STU_LNAME Stephanos Smith Jones Ortiz McKulski STU_MAJOR DEPT_CODE Accounting Accounting Marketing Marketing Statistics ACCT ACCT MKTG MKTG MATH DEPT_NAME Accounting Accounting Marketing Marketing DEPT PHONE 4356 4356 4378 4378 Mathematics 3420 COLLEGE_NAME Business Admin ADVISOR_LNAME Grastrand Business Admin Business Admin Business Admin Arts & Sciences Grastrand ADVISOR OFFICE T201 T201 Gentry T228 Tillery T356 Chen J331 ADVISOR BLDG Torre Building Torre Building Torre Building Torre Building Jones Building ADVISOR PHONE 2115 2115 2123 2159 3209 STU GPA STU_HOURS 3.87 2.78 2.31 3.45 3.58 75 45 117 113 87 STU_CLASS Junior Sophomore Senior Senior Junior 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.