Use the following STUDENT table structure to do question (b). 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

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.