## Schools

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

## Educational_Jobs

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.

## School_Employees

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

## Jobs_at_School

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

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