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 |