## Students

StudentID | FirstName | LastName | DateOfBirth
--- | --- | --- | ---
1 | John | Doe | 2003-06-15
2 | Jane | Smith | 2002-08-27

## Diplomas

DiplomaID | Title | CompletionRequirements | UnitsRequired
--- | --- | --- | ---
1 | Bachelor of Science | Passing Exam | 120
2 | Master of Arts | Submitting Thesis | 60

## Certificates

CertificateID | Title | CompletionRequirements | Duration
--- | --- | --- | ---
1 | Advanced Programming | Passing Exam | 12
2 | Data Analysis | Project Submission | 10

## Subjects

SubjectID | Name | Teacher | MaxScore
--- | --- | --- | ---
1 | Algebra | Mr. Johnson | 100
2 | Calculus | Mrs. Smith | 100

## Enrolment

EnrollmentID | StudentID | SubjectID | StartDate | EndDate
--- | --- | --- | --- | ---
| (→ Students.StudentID) | (→ Subjects.SubjectID) |  |
1 | 1 | 1 | 2022-09-01 | 2022-12-31
2 | 2 | 2 | 2022-09-01 | 2022-12-31

## Grades

GradeID | EnrollmenID | Score | DateAwarded
--- | --- | --- | ---
| (→ Enrolment.EnrollmentID) |  |
1 | 1 | 95 | 2022-12-15
2 | 2 | 85 | 2022-12-15