Teacher

teacherIDnameageexperience
1John Doe325 years
2Jane Smith4810 years
3Michael Brown273 years

Student

studentIDnamegradeteacherID
(→ Teacher.teacherID)
1Alice Johnson91
2Bob Williams102
3Carol Lee93

Subject

subjectIDname
1Mathematics
2English
3History

Class

classIDsubjectIDteacherID
(→ Subject.subjectID)(→ Teacher.teacherID)
111
222
333

Assignment

assignmentIDtitledueDateeducationalMethodparticipantsclassID
(→ Class.classID)
1Math Test2022-06-01 14:00:00Peer Tutoring10 students1
2Literature Essay2022-06-15 14:00:00Peer Tutoring5 students2
3Historical Project2022-07-01 14:00:00Group Work10 students3
4Quiz on Chapters2022-07-15 14:00:00Group Work8 students1
5Book Report Presentation2022-08-01 14:00:00Peer Tutoring6 students2