## HighSchools

id | name
--- | ---
1 | Abc High
2 | Xyz High
3 | Pqr High

## Colleges

id | name
--- | ---
1 | Mnc College
2 | Nmv College
3 | Qrs College

## Students

studentID | firstName | lastName | highschoolId | collegeId | educationId
--- | --- | --- | --- | --- | ---
|  |  | (→ HighSchools.id) | (→ Colleges.id) | (→ Education.id)
1 | John | Doe | 1 | 1 | 1
2 | Jane | Smith | 2 | 2 | 2
3 | Bob | Williams | 3 | 3 | 3

## Education

id | educational_institution | student_enrollment | year
--- | --- | --- | ---
1 | High School | 1000 | 2018
2 | High School | Some other number | 2019
3 | College | 1000 | 2020
4 | College | Another number | 2021