## Students

id | first_name | last_name | email
--- | --- | --- | ---
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

## Courses

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

## Enrollments

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

## Assignments

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

## Submissions

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

## Grades

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