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 |