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....

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. [5 marks]
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.
[10 marks]
c. Using the results of Problem b, draw the Crow’s Foot ERD. [5 marks]
TABLE 1: STUDENT INFO
ATTRIBUTE
NAME
SAMPLE
VALUE
SAMPLE
VALUE
SAMPLE
VALUE
SAMPLE
VALUE
SAMPLE
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 ACCT MKTG MKTG MATH
DEPT_NAME Accounting Accounting Marketing Marketing Mathematics