ASSUMPTION: at University, each student can only declare one major.

It seems correct that each college has many majors, and each college has many students. However, which students are enrolled in which major (fan trap)

Resolve the fan trap issue in a corrected ERD (including PKs & FKs).

CROW'S FOOT NOTATION

MAJOR STUDENT COLLEGE MAJOR ID STUDENT ID COLLEGE_ID COLLEGE ID COLLEGE ID MAJOR_ DESC STUDENT LNAME