HighSchools

idname
1Abc High
2Xyz High
3Pqr High

Colleges

idname
1Mnc College
2Nmv College
3Qrs College

Students

studentIDfirstNamelastNamehighschoolIdcollegeIdeducationId
(→ HighSchools.id)(→ Colleges.id)(→ Education.id)
1JohnDoe111
2JaneSmith222
3BobWilliams333

Education

ideducational_institutionstudent_enrollmentyear
1High School10002018
2High SchoolSome other number2019
3College10002020
4CollegeAnother number2021