Students

StudentIDFirstNameLastNameAcademic_WritingAcademic_Supervisor
1JohnDoeDissertationDr. Jane Smith
2JaneSmithDissertationDr. John Doe
3MaryBrownThesis ProposalDr. Jane Smith
4SteveWhiteThesis ProposalDr. John Doe

Courses

CourseIDTitleDepartment
1Computer ScienceEngineering
2MathematicsScience
3PhysicsScience
4English LiteratureHumanities
5HistoryArts

Enrollments

EnrollmentIDStudentIDCourseIDSemester
(→ Students.StudentID)(→ Courses.CourseID)
1112023-01-01 00:00:00
2222023-01-01 00:00:00
3332023-01-01 00:00:00
4442023-01-01 00:00:00
5552023-01-01 00:00:00

Grades

GradeIDEnrollmentIDGrade
(→ Enrollments.EnrollmentID)
11A
22B
33C
44A
55B