Using the STUDENT table structure shown in Table 1, do the following: a. Write the relational schema and draw its dependency diagram. Identify all dependencies, including all transitive dependencies....

Extracted text: Using the STUDENT table structure shown in Table 1, do the following: a. Write the relational schema and draw its dependency diagram. Identify all dependencies, including all transitive dependencies. b. Write the relational schema and draw the dependency diagram to meet the 3NF requirements to the greatest practical extent possible. If you believe that practical considerations dictate using a 2NF structure, explain why your decision to retain 2NF is appropriate. If necessary, add or modify attributes to create appropriate determinants and to adhere to the naming conventions. c. Using the results of Problem b, draw the Crow's Foot ERD. TABLE 1: STUDENT INFO ATTRIBUTE SAMPLE SAMPLE SAMPLE SAMPLE SAMPLE NAME VALUE VALUE VALUE VALUE VALUE STU_NUM 211343 200128 199876 198648 223456 STU LNAME Stephanos Smith. Jones Ortiz McKulski STU_MAJOR Accounting Accounting Marketing Marketing Statistics DEPT CODE ACCT АССT MKTG MKTG ΜΑΤΗ DEPT NAΜΕ Accounting Accounting Marketing Marketing Mathematics DEPT PHOΝE 4356 4378 4356 4378 3420 Business Business Business Business Arts & COLLEGE_NAME Admin Admin Admin Admin Sciences ADVISOR_LNAME Grastrand Grastrand Gentry Tillery Chen


Extracted text: ADVISOR OFFICE T201 T201 T228 Т356 Ј331 Тorre Тorre Torre Torre Jones ADVISOR_BLDG Building Building Building Building Building ADVISOR_PHONE 2115 2115 2123 2159 3209 STU_GPA 3.87 2.78 2.31 3.45 3.58 STU_HOURS 75 45 117 113 87 STU_CLASS Sophomore Senior Junior Senior Junior