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 |