## courses

courseID | courseName | department | semester | year
--- | --- | --- | --- | ---
1 | Introduction to Computer Science | CS | Fall | 2022
2 | Calculus I | Math | Spring | 2023
3 | Physics I | Physics | Fall | 2022
4 | Literature Survey | English | Winter | 2023
5 | Economic Principles | Business | Spring | 2022

## students

studentID | firstName | lastName | email | major | enrollmentYear
--- | --- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | Computer Science | 2020
2 | Jane | Smith | jane.smith@example.com | Mathematics | 2021
3 | Michael | Brown | michael.brown@example.com | Physics | 2020
4 | Emma | White | emma.white@example.com | English | 2022
5 | David | Black | david.black@example.com | Economics | 2021

## instructors

instructorID | firstName | lastName | email | department
--- | --- | --- | --- | ---
1 | Dr. | Smith | dr.smith@example.com | CS
2 | Professor | Johnson | prof.johnson@example.com | Math
3 | Dr. | Williams | dr.williams@example.com | Physics
4 | Ms. | Garcia | ms.garcia@example.com | English
5 | Mr. | Martinez | mr.martinez@example.com | Economics

## peer_tutoring

sessionID | courseID | startDateTime | endDateTime | participants
--- | --- | --- | --- | ---
| (→ courses.courseID) |  |  |
1 | 1 | 2022-10-10 18:00:00 | 2022-10-10 20:00:00 | 10
2 | 2 | 2023-02-15 16:00:00 | 2023-02-15 18:00:00 | 8
3 | 3 | 2022-10-12 14:00:00 | 2022-10-12 16:00:00 | 12
4 | 4 | 2023-03-10 19:00:00 | 2023-03-10 21:00:00 | 15
5 | 5 | 2022-04-20 13:00:00 | 2022-04-20 15:00:00 | 7

## group_work

assignmentID | courseID | dueDate | maxScore | participants
--- | --- | --- | --- | ---
| (→ courses.courseID) |  |  |
1 | 1 | 2022-10-20 23:59:00 | 100 | 10
2 | 2 | 2023-02-28 23:59:00 | 100 | 8
3 | 3 | 2022-10-27 23:59:00 | 100 | 12
4 | 4 | 2023-03-24 23:59:00 | 100 | 15
5 | 5 | 2022-04-24 23:59:00 | 100 | 7