| studentID | firstName | lastName | dateOfBirth |
|---|---|---|---|
| 1 | John | Doe | 2003-01-01 |
| 2 | Jane | Smith | 2004-02-02 |
| educatorID | firstName | lastName | subject |
|---|---|---|---|
| 1 | Michael | Johnson | Mathematics |
| 2 | Emily | Williams | English |
| 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 |
| curriculumID | name | EducatorID |
|---|---|---|
| (→ Educators.educatorID) | ||
| 1 | Grade 6 Mathematics | 1 |
| 2 | Grade 7 English | 2 |
| materialID | title | url |
|---|---|---|
| 1 | Algebra Book | https://example.com/algebra-book |
| 2 | Grammar Guide | https://example.com/grammar-guide |
| enrollmentID | StudentID | classID | courseMaterialID |
|---|---|---|---|
| (→ Students.studentID) | (→ Classes.classID) | (→ CourseMaterials.materialID) | |
| 1 | 1 | 1 | 1 |
| 2 | 2 | 2 | 2 |
| 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 |