## Students

StudentID | FirstName | LastName | Academic_Writing | Academic_Supervisor
--- | --- | --- | --- | ---
1 | John | Doe | Dissertation | Dr. Jane Smith
2 | Jane | Smith | Dissertation | Dr. John Doe
3 | Mary | Brown | Thesis Proposal | Dr. Jane Smith
4 | Steve | White | Thesis Proposal | Dr. John Doe

## Courses

CourseID | Title | Department
--- | --- | ---
1 | Computer Science | Engineering
2 | Mathematics | Science
3 | Physics | Science
4 | English Literature | Humanities
5 | History | Arts

## Enrollments

EnrollmentID | StudentID | CourseID | Semester
--- | --- | --- | ---
| (→ Students.StudentID) | (→ Courses.CourseID) |
1 | 1 | 1 | 2023-01-01 00:00:00
2 | 2 | 2 | 2023-01-01 00:00:00
3 | 3 | 3 | 2023-01-01 00:00:00
4 | 4 | 4 | 2023-01-01 00:00:00
5 | 5 | 5 | 2023-01-01 00:00:00

## Grades

GradeID | EnrollmentID | Grade
--- | --- | ---
| (→ Enrollments.EnrollmentID) |
1 | 1 | A
2 | 2 | B
3 | 3 | C
4 | 4 | A
5 | 5 | B