Teacher
teacherID | name | age | experience |
1 | John Doe | 32 | 5 years |
2 | Jane Smith | 48 | 10 years |
3 | Michael Brown | 27 | 3 years |
Student
studentID | name | grade | teacherID |
| | | (→ Teacher.teacherID) |
1 | Alice Johnson | 9 | 1 |
2 | Bob Williams | 10 | 2 |
3 | Carol Lee | 9 | 3 |
Subject
subjectID | name |
1 | Mathematics |
2 | English |
3 | History |
Class
classID | subjectID | teacherID |
| (→ Subject.subjectID) | (→ Teacher.teacherID) |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
Assignment
assignmentID | title | dueDate | educationalMethod | participants | classID |
| | | | | (→ Class.classID) |
1 | Math Test | 2022-06-01 14:00:00 | Peer Tutoring | 10 students | 1 |
2 | Literature Essay | 2022-06-15 14:00:00 | Peer Tutoring | 5 students | 2 |
3 | Historical Project | 2022-07-01 14:00:00 | Group Work | 10 students | 3 |
4 | Quiz on Chapters | 2022-07-15 14:00:00 | Group Work | 8 students | 1 |
5 | Book Report Presentation | 2022-08-01 14:00:00 | Peer Tutoring | 6 students | 2 |