Elementary_Schools

SchoolIDNameLocationYearEstablishedNumberOfStudents
1Oakwood ElementaryNew York2000350
2Pine Street ElementaryLos Angeles2010450
3Maple Avenue ElementaryChicago1980600
4Birch Lane ElementaryHouston2005500
5Cedar Drive ElementaryPhiladelphia1995700

Middle_Schools

SchoolIDNameLocationYearEstablishedNumberOfStudents
1Riverdale MiddleNew York2008800
2Sunset Hills MiddleLos Angeles2012900
3Lakeview MiddleChicago19901000
4Woodland Heights MiddleHouston20011100
5Forest Park MiddlePhiladelphia19981200

Head_Teachers

TeacherIDFirstNameLastNamePhoneNumberEmailAddress
1JaneDoe555-123-4567jdoe@example.com
2JohnSmith555-987-6543jsmith@example.com

Elementary_School_Principals

PrincipalIDSchoolIDTeacherID
(→ Elementary_Schools.SchoolID)(→ Head_Teachers.TeacherID)
111
222
331

Middle_School_Principals

PrincipalIDSchoolIDTeacherID
(→ Middle_Schools.SchoolID)(→ Head_Teachers.TeacherID)
111
222
331

Schools

SchoolIDTypeSchoolNameLocationYearEstablishedNumberOfStudents
1ElementaryOakwood ElementaryNew York2000350
2ElementaryPine Street ElementaryLos Angeles2010450
3ElementaryMaple Avenue ElementaryChicago1980600
4ElementaryBirch Lane ElementaryHouston2005500
5ElementaryCedar Drive ElementaryPhiladelphia1995700
6MiddleRiverdale MiddleNew York2008800
7MiddleSunset Hills MiddleLos Angeles2012900
8MiddleLakeview MiddleChicago19901000
9MiddleWoodland Heights MiddleHouston20011100
10MiddleForest Park MiddlePhiladelphia19981200