| id | name | location |
|---|---|---|
| 1 | University A | City X |
| 2 | High School B | City Y |
| 3 | College C | City Z |
| 4 | Primary School D | City W |
| 5 | Technical School E | City V |
| job_id | title | description |
|---|---|---|
| 1 | Teacher | A teacher who teaches various subjects. |
| 2 | Principal | The principal manages a school. |
| 3 | Counselor | A counselor provides guidance to students. |
| 4 | Librarian | A librarian manages library resources. |
| 5 | IT Specialist | An IT specialist maintains computer systems. |
| employee_id | first_name | last_name | job_title | school_id |
|---|---|---|---|---|
| (→ Schools.id) | ||||
| 1 | John | Doe | Teacher | 1 |
| 2 | Jane | Smith | Principal | 2 |
| 3 | Mike | Brown | Counselor | 3 |
| 4 | Alice | Green | Librarian | 4 |
| 5 | Tom | Black | IT Specialist | 5 |
| school_job_id | school_id | job_id | start_date | end_date |
|---|---|---|---|---|
| (→ Schools.id) | (→ Educational_Jobs.job_id) | |||
| 1 | 1 | 1 | 2021-08-01 | None |
| 2 | 1 | 2 | 2021-08-01 | None |
| 3 | 2 | 3 | 2021-08-01 | None |
| 4 | 2 | 4 | 2021-08-01 | None |
| 5 | 3 | 5 | 2021-08-01 | None |
| 8 | 4 | 5 | None | None |
| 9 | 5 | 5 | None | None |
| 10 | 2 | 5 | None | None |
| 11 | 3 | 5 | None | None |
| 12 | 1 | 5 | None | None |
| employee_education_id | employee_id | education_level | major | degree_year |
|---|---|---|---|---|
| (→ School_Employees.employee_id) | ||||
| 1 | 1 | PhD | Mathematics | 2019 |
| 2 | 1 | Master | Physics | 2017 |
| 3 | 2 | Doctorate | English Literature | 2020 |
| 4 | 2 | Bachelor | History | 2016 |
| 5 | 3 | Master | Psychology | 2018 |