| 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 |
| 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 |
| 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 |
| 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 |
| EnrolmentID | StudentID | CourseID |
|---|---|---|
| (→ Students.StudentID) | (→ Courses.CourseID) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | 3 |
| 4 | 4 | 4 |
| 5 | 5 | 5 |
| 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 |
| 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 |