Using the STUDENT table structure attached, write the relational schema and draw its diagram. Identify all dependencies (including all transitive dependencies)
Using the STUDENT table structure shown here, write the relational
schema and draw its diagram. Identify all dependencies (including all
transitive dependencies)
ATTRIBUTE NAME SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE
SAMPLE VALUE
STU_NUM 211343 200128 199876 199876 223456
STU_LNAME Stephance 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 4356 4356 4378 4378 3420