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 |