courses

courseIDcourseNamedepartmentsemesteryear
1Introduction to Computer ScienceCSFall2022
2Calculus IMathSpring2023
3Physics IPhysicsFall2022
4Literature SurveyEnglishWinter2023
5Economic PrinciplesBusinessSpring2022

students

studentIDfirstNamelastNameemailmajorenrollmentYear
1JohnDoejohn.doe@example.comComputer Science2020
2JaneSmithjane.smith@example.comMathematics2021
3MichaelBrownmichael.brown@example.comPhysics2020
4EmmaWhiteemma.white@example.comEnglish2022
5DavidBlackdavid.black@example.comEconomics2021

instructors

instructorIDfirstNamelastNameemaildepartment
1Dr.Smithdr.smith@example.comCS
2ProfessorJohnsonprof.johnson@example.comMath
3Dr.Williamsdr.williams@example.comPhysics
4Ms.Garciams.garcia@example.comEnglish
5Mr.Martinezmr.martinez@example.comEconomics

peer_tutoring

sessionIDcourseIDstartDateTimeendDateTimeparticipants
(→ courses.courseID)
112022-10-10 18:00:002022-10-10 20:00:0010
222023-02-15 16:00:002023-02-15 18:00:008
332022-10-12 14:00:002022-10-12 16:00:0012
442023-03-10 19:00:002023-03-10 21:00:0015
552022-04-20 13:00:002022-04-20 15:00:007

group_work

assignmentIDcourseIDdueDatemaxScoreparticipants
(→ courses.courseID)
112022-10-20 23:59:0010010
222023-02-28 23:59:001008
332022-10-27 23:59:0010012
442023-03-24 23:59:0010015
552022-04-24 23:59:001007