Using the STUDENT table structure shown in Table P6.4, do the following:

a. Write the relational schema, draw its dependency diagram, and 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 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. Draw the Crow's Foot ERD.

Transcribed Image Text:

Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value STU_NUM STU LNAME STU MAJOR DEPT CODE DEPT NAME DEPT PHONE COLLEGE NAME Business Admin Business Admin Business Admin Business Admin Arts & Sciences ADVISOR LNAME Grastrand ADVISOR OFFICE T201 ADVISOR_BLDG Torre Building Tore Building Torre Building Torre Building Jones Building ADVISOR PHONE 2115 STU GPA STU HOURS STU CLASS 211343 Stephanos Accounting ACCT Accounting 4356 00128 Smith Accounting Marketing ACCT Accounting 4356 223456 McKulski Statistics MATH Mathe 3420 199876 199876 Ortiz Marketing MKTG Marketing 4378 Jones MKTG Marketing 4378 matics Grastrand Gentry Tillery Chen T201 T228 T356 J331 2115 2.78 45 Sophomore 2123 3.87 75 Junior 2159 3.45 113 Senior 3209 3.58 87 Junior 2.31 Senior