Students
id | firstName | lastName | birthDate | schoolId |
1 | John | Doe | 2008-03-15 | 1 |
2 | Jane | Smith | 2007-09-20 | 2 |
3 | Alice | Brown | 2006-11-17 | 3 |
4 | Tom | White | 2005-05-13 | 4 |
5 | Emma | Black | 2004-07-22 | 1 |
Teachers
id | firstName | lastName | headTeacher | schoolId |
| | | | (→ Schools.id) |
1 | Mr. | Jones | 1 | 1 |
2 | Ms. | Williams | 0 | 2 |
3 | Mrs. | Thompson | 1 | 3 |
4 | Mr. | Martin | 0 | 4 |
5 | Dr. | Green | 1 | 1 |
Classes
classId | className | teacherId | schoolId |
| | (→ Teachers.id) | (→ Schools.id) |
1 | Math | 1 | 1 |
2 | English | 2 | 2 |
3 | History | 3 | 3 |
4 | Science | 4 | 4 |
5 | Art | 1 | 1 |
Enrollments
enrollmentId | studentId | classId | grade |
| (→ Students.id) | (→ Classes.classId) | |
1 | 1 | 1 | A |
2 | 2 | 2 | B |
3 | 3 | 3 | C |
4 | 4 | 4 | A |
5 | 5 | 1 | B |