Using the STUDENT table structure shown in the below 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. 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.

Draw the Crow’s Foot ERD.

 

Transcribed Image Text:

ATTRIBUTE NAME SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALLUE STU NUM 211343 200128 199876 199876 223456 Stephanos Accounting STU LNAME Smith Jones Ortiz McKulski Accounting Statistics MATH STU MAJOR Marketing MKTG Marketing MKTG DEPT CODE АССТ АССТ DEPT NAME Accounting Accounting Marketing Marketing Mathematics DEPT PHONE 4356 4356 4378 4378 3420 COLLEGE NAME Business Admin Business Admin Business Admin Business Admin Arts & Sciences ADVISOR LNAME Grastrand Grastrand Gentry Tillery Chen ADVISOR OFFICE T201 T201 T228 T356 J331 ADVISOR BLDG Torre Buikding Torre Building Torre Building Torre Building Jones 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 Junior Sophomore Senior Senior Junior ATTRIBUTE NAME SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALLUE STU NUM 211343 200128 199876 199876 223456 Stephanos Accounting STU LNAME Smith Jones Ortiz McKulski Accounting Statistics MATH STU MAJOR Marketing MKTG Marketing MKTG DEPT CODE АССТ АССТ DEPT NAME Accounting Accounting Marketing Marketing Mathematics DEPT PHONE 4356 4356 4378 4378 3420 COLLEGE NAME Business Admin Business Admin Business Admin Business Admin Arts & Sciences ADVISOR LNAME Grastrand Grastrand Gentry Tillery Chen ADVISOR OFFICE T201 T201 T228 T356 J331 ADVISOR BLDG Torre Buikding Torre Building Torre Building Torre Building Jones 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 Junior Sophomore Senior Senior Junior