| 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 |
| studentID | firstName | lastName | 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 |
| instructorID | firstName | lastName | 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 |
| 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 |
| 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 |