Districts

IDNamePopulation
1District120000
2District230000
3District340000
4District450000
5District560000

Programs

IDNameDescription
1Special_EducationA program designed for students with special needs
2General_EducationStandard curriculum offered in most schools
3Vocational_TrainingCareer-focused education and training
4Art_and_MusicProgram focused on creative arts
5SportsPhysical fitness and sports instruction

Students

IDFirstNameLastNameAge
1JohnDoe18
2JaneSmith17
3MikeBrown19
4EmmaWilliams16
5JackJohnson20

Teachers

IDFirstNameLastNameSubject
1Mr.SmithMath
2Ms.JonesEnglish
3Dr.BlackHistory
4Mr.WhiteBiology
5Mrs.GreenChemistry

Schools

IDNameAddressDistrictID
(→ Districts.ID)
1School1Address11
2School2Address22
3School3Address33
4School4Address44
5School5Address55

School_Students

StudentIDSchoolIDEnrollmentDate
(→ Students.ID)(→ Schools.ID)
112022-09-01
212022-09-01
322022-09-01
422022-09-01
532022-09-01

School_Teachers

TeacherIDSchoolIDHireDate
(→ Teachers.ID)(→ Schools.ID)
112021-09-01
212021-09-01
322021-09-01
422021-09-01
532021-09-01

Districts_Programs

DistrictIDProgramIDImplemented
(→ Districts.ID)(→ Programs.ID)
111
121
211
221
311
410
510

Students_Programs

StudentIDProgramIDStartDateEndDate
(→ Students.ID)(→ Programs.ID)
112022-08-012023-05-31
212022-08-012023-05-31
322022-08-012023-05-31
422022-08-012023-05-31
512022-08-012023-05-31