Students
StudentID | FirstName | LastName | Age | Major |
1 | John | Doe | 20 | Computer Science |
2 | Jane | Smith | 22 | Mathematics |
CourseEnrollment
EnrollmentID | StudentID | CourseID |
| (→ Students.StudentID) | (→ Courses.CourseID) |
1 | 1 | 1 |
2 | 2 | 2 |
Professors
ProfessorID | FirstName | LastName | Department |
1 | Alice | Brown | Physics |
2 | David | Black | Chemistry |
Assessments
AssessmentID | CourseID | AssessorID | AssessmentTypeID | Score | Date |
| (→ Courses.CourseID) | (→ Professors.ProfessorID) | (→ AssessmentTypes.TypeID) | | |
1 | 1 | 1 | 1 | 85 | 2023-01-01 10:00:00 |
2 | 1 | 2 | 1 | 90 | 2023-01-01 11:00:00 |
3 | 2 | 1 | 2 | 75 | 2023-01-02 10:00:00 |
4 | 2 | 2 | 2 | 80 | 2023-01-02 11:00:00 |