## Students

studentID | firstName | lastName | dateOfBirth
--- | --- | --- | ---
1 | John | Doe | 2003-01-01
2 | Jane | Smith | 2004-02-02

## Educators

educatorID | firstName | lastName | subject
--- | --- | --- | ---
1 | Michael | Johnson | Mathematics
2 | Emily | Williams | English

## Classes

classID | title | startDate | endDate | EducatorID
--- | --- | --- | --- | ---
(→ Enrollments.classID) |  |  |  | (→ Educators.educatorID)
1 | Math Class A | 2023-09-01 | 2023-12-20 | 1
2 | English Class B | 2023-09-01 | 2023-12-20 | 2

## Curriculums

curriculumID | name | EducatorID
--- | --- | ---
|  | (→ Educators.educatorID)
1 | Grade 6 Mathematics | 1
2 | Grade 7 English | 2

## CourseMaterials

materialID | title | url
--- | --- | ---
1 | Algebra Book | https://example.com/algebra-book
2 | Grammar Guide | https://example.com/grammar-guide

## Enrollments

enrollmentID | StudentID | classID | courseMaterialID
--- | --- | --- | ---
| (→ Students.studentID) | (→ Classes.classID) | (→ CourseMaterials.materialID)
1 | 1 | 1 | 1
2 | 2 | 2 | 2

## Lessons

lessonID | content | educationalMethod | curriculumID | classID
--- | --- | --- | --- | ---
|  |  | (→ Curriculums.curriculumID) | (→ Classes.classID)
1 | Lesson on linear equations | Online Learning | 1 | 1
2 | Lesson on sentence structure | Online Learning | 2 | 2
3 | Introduction to algebra | Classroom Teaching | 1 | 3
4 | Vocabulary building | Classroom Teaching | 2 | 4