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 |