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 |