Students

StudentIDFirstNameLastNameDateOfBirth
1JohnDoe2003-06-15
2JaneSmith2002-08-27

Diplomas

DiplomaIDTitleCompletionRequirementsUnitsRequired
1Bachelor of SciencePassing Exam120
2Master of ArtsSubmitting Thesis60

Certificates

CertificateIDTitleCompletionRequirementsDuration
1Advanced ProgrammingPassing Exam12
2Data AnalysisProject Submission10

Subjects

SubjectIDNameTeacherMaxScore
1AlgebraMr. Johnson100
2CalculusMrs. Smith100

Enrolment

EnrollmentIDStudentIDSubjectIDStartDateEndDate
(→ Students.StudentID)(→ Subjects.SubjectID)
1112022-09-012022-12-31
2222022-09-012022-12-31

Grades

GradeIDEnrollmenIDScoreDateAwarded
(→ Enrolment.EnrollmentID)
11952022-12-15
22852022-12-15