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 |