## Students

StudentID | Name | Age | Major
--- | --- | --- | ---
1 | John Doe | 20 | Computer Science
2 | Jane Smith | 21 | Mathematics
3 | Michael Johnson | 22 | Physics
4 | Emma Brown | 23 | Biology
5 | David Wilson | 24 | History

## Diplomas

DiplomaID | Name | Description
--- | --- | ---
1 | Bachelor of Computer Science | A degree in computer science
2 | Bachelor of Mathematics | A degree in mathematics
3 | Bachelor of Physics | A degree in physics
4 | Bachelor of Biology | A degree in biology
5 | Bachelor of History | A degree in history

## Certificates

CertificateID | Name | Description
--- | --- | ---
1 | Data Structures Certification | Certification in data structures
2 | Algebra Certification | Certification in algebra
3 | Calculus Certification | Certification in calculus
4 | Quantum Mechanics Certification | Certification in quantum mechanics
5 | Ancient Civilizations Certification | Certification in ancient civilizations

## CompletionRequirements

RequirementID | RequirementName | Type
--- | --- | ---
1 | Passing Exam | Exam
2 | Writing a Research Paper | Paper
3 | Group Project | Project
4 | Individual Internship | Internship
5 | Teaching Assistance | Assistantship

## CourseEnrolment

EnrolmentID | StudentID | CourseID
--- | --- | ---
| (→ Students.StudentID) | (→ Courses.CourseID)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3
4 | 4 | 4
5 | 5 | 5

## Courses

CourseID | Title | Description | RequiredDiplomaID | RequiredCertificateID
--- | --- | --- | --- | ---
|  |  | (→ Diplomas.DiplomaID) | (→ Certificates.CertificateID)
1 | Introduction to Programming |  | 1 | 1
2 | Discrete Mathematics |  | 1 | 2
3 | General Relativity |  | 2 | 3
4 | Evolutionary Biology |  | 3 | 4
5 | World War II |  | 4 | 5

## StudentProgress

ProgressID | StudentID | CourseID | CompletionRequirementID
--- | --- | --- | ---
| (→ Students.StudentID) | (→ Courses.CourseID) | (→ CompletionRequirements.RequirementID)
1 | 1 | 1 | 1
2 | 2 | 2 | 2
3 | 3 | 3 | 3
4 | 4 | 4 | 4
5 | 5 | 5 | 5