Using the STUDENT table structure shown in Table P$6\mathrm{.}4,$ do the following:

Table P$6\mathrm{.}4$

Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value

STU$\_$NUM $211343200128199876198648223456$

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

DEPT$\_$PHONE $43564356437843783420$

COLLEGE$\_$NAME Business Admin Business Admin Business Admin Business Admin Arts & Sciences

ADVISOR$\_$LNAME Grastrand Grastrand Gentry Tillery Chen

ADVISOR$\_$OFFICE T$201$ T$201$ T$228$ T$356$ J$331$

ADVISOR$\_$BLDG Torre Building Torre Building Torre Building Torre Building Jones Building

ADVISOR$\_$PHONE $21152115212321593209$

STU$\_$GPA $3\mathrm{.}872\mathrm{.}782\mathrm{.}313\mathrm{.}453\mathrm{.}58$

STU$\_$HOURS $754511711387$

STU$\_$CLASS Junior Sophomore Senior Senior Junior

Enlarge Table

Write the relational schema and draw its dependency diagram. Identify all dependencies, including all transitive dependencies.

Write the relational schema and draw the dependency diagram to meet the $3$NF requirements to the greatest practical extent possible. If you believe that practical considerations dictate using a $2$NF structure, explain why your decision to retain $2$NF is appropriate. If necessary, add or modify attributes to create appropriate determinants and to adhere to the naming conventions.

Using the results of Problem $4,$ draw the Crow's Foot ERD.