| ID | Name | Population |
|---|---|---|
| 1 | District1 | 20000 |
| 2 | District2 | 30000 |
| 3 | District3 | 40000 |
| 4 | District4 | 50000 |
| 5 | District5 | 60000 |
| 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 |
| ID | FirstName | LastName | Age |
|---|---|---|---|
| 1 | John | Doe | 18 |
| 2 | Jane | Smith | 17 |
| 3 | Mike | Brown | 19 |
| 4 | Emma | Williams | 16 |
| 5 | Jack | Johnson | 20 |
| ID | FirstName | LastName | Subject |
|---|---|---|---|
| 1 | Mr. | Smith | Math |
| 2 | Ms. | Jones | English |
| 3 | Dr. | Black | History |
| 4 | Mr. | White | Biology |
| 5 | Mrs. | Green | Chemistry |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |