Students

StudentIDNameAgeMajor
1John Doe20Computer Science
2Jane Smith21Mathematics
3Michael Johnson22Physics
4Emma Brown23Biology
5David Wilson24History

Diplomas

DiplomaIDNameDescription
1Bachelor of Computer ScienceA degree in computer science
2Bachelor of MathematicsA degree in mathematics
3Bachelor of PhysicsA degree in physics
4Bachelor of BiologyA degree in biology
5Bachelor of HistoryA degree in history

Certificates

CertificateIDNameDescription
1Data Structures CertificationCertification in data structures
2Algebra CertificationCertification in algebra
3Calculus CertificationCertification in calculus
4Quantum Mechanics CertificationCertification in quantum mechanics
5Ancient Civilizations CertificationCertification in ancient civilizations

CompletionRequirements

RequirementIDRequirementNameType
1Passing ExamExam
2Writing a Research PaperPaper
3Group ProjectProject
4Individual InternshipInternship
5Teaching AssistanceAssistantship

CourseEnrolment

EnrolmentIDStudentIDCourseID
(→ Students.StudentID)(→ Courses.CourseID)
111
222
333
444
555

Courses

CourseIDTitleDescriptionRequiredDiplomaIDRequiredCertificateID
(→ Diplomas.DiplomaID)(→ Certificates.CertificateID)
1Introduction to Programming11
2Discrete Mathematics12
3General Relativity23
4Evolutionary Biology34
5World War II45

StudentProgress

ProgressIDStudentIDCourseIDCompletionRequirementID
(→ Students.StudentID)(→ Courses.CourseID)(→ CompletionRequirements.RequirementID)
1111
2222
3333
4444
5555