| id | name |
|---|---|
| 1 | Abc High |
| 2 | Xyz High |
| 3 | Pqr High |
| id | name |
|---|---|
| 1 | Mnc College |
| 2 | Nmv College |
| 3 | Qrs College |
| 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 |
| 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 |