Schools

idnamelocation
1University ACity X
2High School BCity Y
3College CCity Z
4Primary School DCity W
5Technical School ECity V

Educational_Jobs

job_idtitledescription
1TeacherA teacher who teaches various subjects.
2PrincipalThe principal manages a school.
3CounselorA counselor provides guidance to students.
4LibrarianA librarian manages library resources.
5IT SpecialistAn IT specialist maintains computer systems.

School_Employees

employee_idfirst_namelast_namejob_titleschool_id
(→ Schools.id)
1JohnDoeTeacher1
2JaneSmithPrincipal2
3MikeBrownCounselor3
4AliceGreenLibrarian4
5TomBlackIT Specialist5

Jobs_at_School

school_job_idschool_idjob_idstart_dateend_date
(→ Schools.id)(→ Educational_Jobs.job_id)
1112021-08-01None
2122021-08-01None
3232021-08-01None
4242021-08-01None
5352021-08-01None
845NoneNone
955NoneNone
1025NoneNone
1135NoneNone
1215NoneNone

Employee_Education

employee_education_idemployee_ideducation_levelmajordegree_year
(→ School_Employees.employee_id)
11PhDMathematics2019
21MasterPhysics2017
32DoctorateEnglish Literature2020
42BachelorHistory2016
53MasterPsychology2018