## 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