Students

StudentIDFirstNameLastNameDateOfBirth
1JohnDoe2001-03-25
2JaneSmith2002-06-17
3AliceJohnson2000-09-12
4BobWilliams1998-11-20
5EmmaMiller2003-02-05

Programs

ProgramIDProgramNameAwardType
1Computer ScienceDiploma
2Graphic DesignDiploma
3Web DevelopmentCertificate
4Data AnalysisCertificate
5Mobile App DevelopmentCertificate

CompletionRequirements

RequirementIDRequirementNameIsMet
1Passing Exam1
2Project Submission0
3Attendance1
4Internship0
5Final Presentation1

Enrollments

EnrollmentIDStudentIDProgramID
(→ Students.StudentID)(→ Programs.ProgramID)
111
222
333
444
555

ProgressReports

ReportIDEnrollmentIDCompletionRequirementIDMetDate
(→ Enrollments.EnrollmentID)(→ CompletionRequirements.RequirementID)
1112023-06-15
212None
3212023-07-15
4232023-08-15
5312023-09-15

Scores

ScoreIDEnrollmentIDTestScore
(→ Enrollments.EnrollmentID)
1185
2290
3375
4488
5592