## Students

StudentID | FirstName | LastName | Age | Major
--- | --- | --- | --- | ---
1 | John | Doe | 20 | Computer Science
2 | Jane | Smith | 22 | Mathematics

## AssessmentTypes

TypeID | Name
--- | ---
1 | Exam
2 | Quiz

## 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