## Schools

id | schoolName | headTeacher | address | phoneNumber
--- | --- | --- | --- | ---
1 | Elementary School | Mrs. Thompson | 123 Main St. | 555-0198
2 | Elementary School | Mr. Smith | 456 Elm St. | 555-0199
3 | Middle School | Mrs. Thompson | 789 Oak St. | 555-0200
4 | Middle School | Ms. Johnson | 101 Pine St. | 555-0201

## Teachers

id | firstName | lastName | email | phoneNumber | subject
--- | --- | --- | --- | --- | ---
1 | John | Doe | johnd@example.com | 555-0111 | Math
2 | Jane | Smith | janes@example.com | 555-0112 | English
3 | Bob | White | bwhite@example.com | 555-0113 | History
4 | Alice | Green | agreen@example.com | 555-0114 | Art
5 | Tom | Black | tblack@example.com | 555-0115 | Physical Education

## Classes

id | className | teacherId
--- | --- | ---
|  | (→ Teachers.id)
1 | Class1 | 1
2 | Class2 | 2
3 | Class3 | 3
4 | Class4 | 4
5 | Class5 | 5

## Students

id | firstName | lastName | classId
--- | --- | --- | ---
|  |  | (→ Classes.id)
1 | StudentA | LastA | 1
2 | StudentB | LastB | 2
3 | StudentC | LastC | 3
4 | StudentD | LastD | 4
5 | StudentE | LastE | 5