Students

studentIDfirstNamelastNamedateOfBirth
1JohnDoe2003-01-01
2JaneSmith2004-02-02

Educators

educatorIDfirstNamelastNamesubject
1MichaelJohnsonMathematics
2EmilyWilliamsEnglish

Classes

classIDtitlestartDateendDateEducatorID
(→ Enrollments.classID)(→ Educators.educatorID)
1Math Class A2023-09-012023-12-201
2English Class B2023-09-012023-12-202

Curriculums

curriculumIDnameEducatorID
(→ Educators.educatorID)
1Grade 6 Mathematics1
2Grade 7 English2

CourseMaterials

materialIDtitleurl
1Algebra Bookhttps://example.com/algebra-book
2Grammar Guidehttps://example.com/grammar-guide

Enrollments

enrollmentIDStudentIDclassIDcourseMaterialID
(→ Students.studentID)(→ Classes.classID)(→ CourseMaterials.materialID)
1111
2222

Lessons

lessonIDcontenteducationalMethodcurriculumIDclassID
(→ Curriculums.curriculumID)(→ Classes.classID)
1Lesson on linear equationsOnline Learning11
2Lesson on sentence structureOnline Learning22
3Introduction to algebraClassroom Teaching13
4Vocabulary buildingClassroom Teaching24