Elementary_Schools
SchoolID | Name | Location | YearEstablished | NumberOfStudents |
1 | Oakwood Elementary | New York | 2000 | 350 |
2 | Pine Street Elementary | Los Angeles | 2010 | 450 |
3 | Maple Avenue Elementary | Chicago | 1980 | 600 |
4 | Birch Lane Elementary | Houston | 2005 | 500 |
5 | Cedar Drive Elementary | Philadelphia | 1995 | 700 |
Middle_Schools
SchoolID | Name | Location | YearEstablished | NumberOfStudents |
1 | Riverdale Middle | New York | 2008 | 800 |
2 | Sunset Hills Middle | Los Angeles | 2012 | 900 |
3 | Lakeview Middle | Chicago | 1990 | 1000 |
4 | Woodland Heights Middle | Houston | 2001 | 1100 |
5 | Forest Park Middle | Philadelphia | 1998 | 1200 |
Head_Teachers
TeacherID | FirstName | LastName | PhoneNumber | EmailAddress |
1 | Jane | Doe | 555-123-4567 | jdoe@example.com |
2 | John | Smith | 555-987-6543 | jsmith@example.com |
Elementary_School_Principals
PrincipalID | SchoolID | TeacherID |
| (→ Elementary_Schools.SchoolID) | (→ Head_Teachers.TeacherID) |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 1 |
Middle_School_Principals
PrincipalID | SchoolID | TeacherID |
| (→ Middle_Schools.SchoolID) | (→ Head_Teachers.TeacherID) |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 1 |
Schools
SchoolID | Type | SchoolName | Location | YearEstablished | NumberOfStudents |
1 | Elementary | Oakwood Elementary | New York | 2000 | 350 |
2 | Elementary | Pine Street Elementary | Los Angeles | 2010 | 450 |
3 | Elementary | Maple Avenue Elementary | Chicago | 1980 | 600 |
4 | Elementary | Birch Lane Elementary | Houston | 2005 | 500 |
5 | Elementary | Cedar Drive Elementary | Philadelphia | 1995 | 700 |
6 | Middle | Riverdale Middle | New York | 2008 | 800 |
7 | Middle | Sunset Hills Middle | Los Angeles | 2012 | 900 |
8 | Middle | Lakeview Middle | Chicago | 1990 | 1000 |
9 | Middle | Woodland Heights Middle | Houston | 2001 | 1100 |
10 | Middle | Forest Park Middle | Philadelphia | 1998 | 1200 |