Students

studentIDfirstNamelastNamedateOfBirth
1JohnDoe2003-09-17
2JaneSmith2002-08-23
3MichaelJohnson2001-06-15
4EmilyWilliams2000-05-01
5DavidBrown1999-04-10

Teachers

teacherIDfirstNamelastNameyearsExperience
1Mr.White10
2Ms.Green8
3Mr.Black12
4Ms.Yellow5
5Mr.Red7

Subjects

subjectIDname
1Mathematics
2English
3History
4Science
5Art

Classes

classIDsubjectIDteacherID
(→ Subjects.subjectID)(→ Teachers.teacherID)
111
222
333
444
555

Participants

participantIDclassIDrole
(→ Classes.classID)
11Student
21Peer Tutor
32Student
42Group Worker
53Student

Peer_Tutoring

tutoringIDparticipantIDtuteeIDsessionDate
(→ Participants.participantID)(→ Participants.participantID)
1122023-01-15
2352023-02-15
3412023-03-15
4242023-04-15
5532023-05-15

Group_Work

groupWorkIDparticipantIDtaskDescriptioncompletionStatus
(→ Participants.participantID)
11Math homeworkCompleted
22English projectIn Progress
33History reportNot Started
44Science experimentPending Review
55Art assignmentApproved