Use the following STUDENT table structure to do question (a) . The sample values of data are provided for your consideration, but you should also base your answers on the common sense about a university environment.

Table: STUDENT

Attribute Name	Sample Value	Sample Value	Sample Value	Sample Value	Sample Value
STU_NUM	211343	200128	199876	199876	223456
STU_NAME	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	4356	4356	4378	4378	3420
SCHOOL_NAME	Business	Business	Business	Business	Arts & Sci
TEACHER_NAME	Grastrand	Grastrand	Gentry	Tillery	Chen
TEACHER _OFFICE	T201	T201	T228	T356	J331
TEACHER _BLDG	Torre	Torre	Torre	Torre	Jones
BLDG_MANAGER	Smith	Smith	Smith	Smith	Hanks
STU_HOURS	75	45	117	113	87
STU_CLASS	Junior	Sophomore	Senior	Senior	Junior
COURSE_NAME	ACCT I	ACCT II	ACCT I	ACCT II	ACCT II
COURSE_SECTION	001	001	002	001	003
COURSE_CREDITS	3	4	3	4	4
COURSE_GRADE	A	B	C	A	B

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