## Districts

ID | Name | Population
--- | --- | ---
1 | District1 | 20000
2 | District2 | 30000
3 | District3 | 40000
4 | District4 | 50000
5 | District5 | 60000

## Programs

ID | Name | Description
--- | --- | ---
1 | Special_Education | A program designed for students with special needs
2 | General_Education | Standard curriculum offered in most schools
3 | Vocational_Training | Career-focused education and training
4 | Art_and_Music | Program focused on creative arts
5 | Sports | Physical fitness and sports instruction

## Students

ID | FirstName | LastName | Age
--- | --- | --- | ---
1 | John | Doe | 18
2 | Jane | Smith | 17
3 | Mike | Brown | 19
4 | Emma | Williams | 16
5 | Jack | Johnson | 20

## Teachers

ID | FirstName | LastName | Subject
--- | --- | --- | ---
1 | Mr. | Smith | Math
2 | Ms. | Jones | English
3 | Dr. | Black | History
4 | Mr. | White | Biology
5 | Mrs. | Green | Chemistry

## Schools

ID | Name | Address | DistrictID
--- | --- | --- | ---
|  |  | (→ Districts.ID)
1 | School1 | Address1 | 1
2 | School2 | Address2 | 2
3 | School3 | Address3 | 3
4 | School4 | Address4 | 4
5 | School5 | Address5 | 5

## School_Students

StudentID | SchoolID | EnrollmentDate
--- | --- | ---
(→ Students.ID) | (→ Schools.ID) |
1 | 1 | 2022-09-01
2 | 1 | 2022-09-01
3 | 2 | 2022-09-01
4 | 2 | 2022-09-01
5 | 3 | 2022-09-01

## School_Teachers

TeacherID | SchoolID | HireDate
--- | --- | ---
(→ Teachers.ID) | (→ Schools.ID) |
1 | 1 | 2021-09-01
2 | 1 | 2021-09-01
3 | 2 | 2021-09-01
4 | 2 | 2021-09-01
5 | 3 | 2021-09-01

## Districts_Programs

DistrictID | ProgramID | Implemented
--- | --- | ---
(→ Districts.ID) | (→ Programs.ID) |
1 | 1 | 1
1 | 2 | 1
2 | 1 | 1
2 | 2 | 1
3 | 1 | 1
4 | 1 | 0
5 | 1 | 0

## Students_Programs

StudentID | ProgramID | StartDate | EndDate
--- | --- | --- | ---
(→ Students.ID) | (→ Programs.ID) |  |
1 | 1 | 2022-08-01 | 2023-05-31
2 | 1 | 2022-08-01 | 2023-05-31
3 | 2 | 2022-08-01 | 2023-05-31
4 | 2 | 2022-08-01 | 2023-05-31
5 | 1 | 2022-08-01 | 2023-05-31