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 |