8C.  Show at Least 1 Relation in 2NF. 

 

Include Transitive Dependencies (But NO Partial Dependencies)

 

Assume that each major had one, and only one advisor. In that case:

 

STUDENT

 

Would be unnecessary since knowing a student’s major would sufficiently determine the student’s advisor.