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 |