Students

idfirst_namelast_nameemail
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com
3AliceBrownalice.brown@example.com
4MichaelGreenmichael.green@example.com
5EmmaWhiteemma.white@example.com

Courses

course_idcourse_nameinstructor_name
1Introduction to Computer ScienceDr. Smith
2Calculus IProfessor Brown
3English LiteratureDr. Green
4World HistoryProfessor White
5BiologyDr. Doe

Enrollments

enrollment_idstudent_idcourse_id
(→ Students.id)(→ Courses.course_id)
111
223
332
444
555

Assignments

assignment_iddatetimedescriptiongrade
12023-01-1610:00 AMWrite a paper on computer science history9.0
22023-02-082:00 PMComplete calculus homework set 78.5
32023-02-223:00 PMRead and analyze two novels8.0
42023-03-1410:00 AMPresent biology lab report9.5
52023-03-282:00 PMResearch and write an essay on global warming9.0

Submissions

submission_idstudent_idassignment_idfile_pathscoresubmitted_time
(→ Students.id)(→ Assignments.assignment_id)
111/home/user/submission1.pdf9.52024-02-19 14:44:34
222/home/user/submission2.docx8.82024-02-19 14:44:34
333/home/user/submission3.pdf8.22024-02-19 14:44:34
444/home/user/submission4.pptx9.32024-02-19 14:44:34
555/home/user/submission5.txt9.72024-02-19 14:44:34

Grades

grade_idstudent_idcourse_idfinal_gradesemester
(→ Students.id)(→ Courses.course_id)
1118.5Fall 2022
2238.8Spring 2023
3327.9Fall 2022
4449.3Winter 2023
5559.7Spring 2023