Students

idfirstNamelastNamebirthDateschoolId
1JohnDoe2008-03-151
2JaneSmith2007-09-202
3AliceBrown2006-11-173
4TomWhite2005-05-134
5EmmaBlack2004-07-221

Teachers

idfirstNamelastNameheadTeacherschoolId
(→ Schools.id)
1Mr.Jones11
2Ms.Williams02
3Mrs.Thompson13
4Mr.Martin04
5Dr.Green11

Classes

classIdclassNameteacherIdschoolId
(→ Teachers.id)(→ Schools.id)
1Math11
2English22
3History33
4Science44
5Art11

Enrollments

enrollmentIdstudentIdclassIdgrade
(→ Students.id)(→ Classes.classId)
111A
222B
333C
444A
551B