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 |