## 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