Schools

idschoolNameheadTeacheraddressphoneNumber
1Elementary SchoolMrs. Thompson123 Main St.555-0198
2Elementary SchoolMr. Smith456 Elm St.555-0199
3Middle SchoolMrs. Thompson789 Oak St.555-0200
4Middle SchoolMs. Johnson101 Pine St.555-0201

Teachers

idfirstNamelastNameemailphoneNumbersubject
1JohnDoejohnd@example.com555-0111Math
2JaneSmithjanes@example.com555-0112English
3BobWhitebwhite@example.com555-0113History
4AliceGreenagreen@example.com555-0114Art
5TomBlacktblack@example.com555-0115Physical Education

Classes

idclassNameteacherId
(→ Teachers.id)
1Class11
2Class22
3Class33
4Class44
5Class55

Students

idfirstNamelastNameclassId
(→ Classes.id)
1StudentALastA1
2StudentBLastB2
3StudentCLastC3
4StudentDLastD4
5StudentELastE5