id | first_name | last_name | |
---|---|---|---|
1 | John | Doe | john.doe@example.com |
2 | Jane | Smith | jane.smith@example.com |
3 | Alice | Brown | alice.brown@example.com |
4 | Michael | Green | michael.green@example.com |
5 | Emma | White | emma.white@example.com |
course_id | course_name | instructor_name |
---|---|---|
1 | Introduction to Computer Science | Dr. Smith |
2 | Calculus I | Professor Brown |
3 | English Literature | Dr. Green |
4 | World History | Professor White |
5 | Biology | Dr. Doe |
enrollment_id | student_id | course_id |
---|---|---|
(→ Students.id) | (→ Courses.course_id) | |
1 | 1 | 1 |
2 | 2 | 3 |
3 | 3 | 2 |
4 | 4 | 4 |
5 | 5 | 5 |
assignment_id | date | time | description | grade |
---|---|---|---|---|
1 | 2023-01-16 | 10:00 AM | Write a paper on computer science history | 9.0 |
2 | 2023-02-08 | 2:00 PM | Complete calculus homework set 7 | 8.5 |
3 | 2023-02-22 | 3:00 PM | Read and analyze two novels | 8.0 |
4 | 2023-03-14 | 10:00 AM | Present biology lab report | 9.5 |
5 | 2023-03-28 | 2:00 PM | Research and write an essay on global warming | 9.0 |
submission_id | student_id | assignment_id | file_path | score | submitted_time |
---|---|---|---|---|---|
(→ Students.id) | (→ Assignments.assignment_id) | ||||
1 | 1 | 1 | /home/user/submission1.pdf | 9.5 | 2024-02-19 14:44:34 |
2 | 2 | 2 | /home/user/submission2.docx | 8.8 | 2024-02-19 14:44:34 |
3 | 3 | 3 | /home/user/submission3.pdf | 8.2 | 2024-02-19 14:44:34 |
4 | 4 | 4 | /home/user/submission4.pptx | 9.3 | 2024-02-19 14:44:34 |
5 | 5 | 5 | /home/user/submission5.txt | 9.7 | 2024-02-19 14:44:34 |
grade_id | student_id | course_id | final_grade | semester |
---|---|---|---|---|
(→ Students.id) | (→ Courses.course_id) | |||
1 | 1 | 1 | 8.5 | Fall 2022 |
2 | 2 | 3 | 8.8 | Spring 2023 |
3 | 3 | 2 | 7.9 | Fall 2022 |
4 | 4 | 4 | 9.3 | Winter 2023 |
5 | 5 | 5 | 9.7 | Spring 2023 |