Students

StudentIDFirstNameLastNameAgeMajor
1JohnDoe20Computer Science
2JaneSmith22Mathematics

AssessmentTypes

TypeIDName
1Exam
2Quiz

CourseEnrollment

EnrollmentIDStudentIDCourseID
(→ Students.StudentID)(→ Courses.CourseID)
111
222

Professors

ProfessorIDFirstNameLastNameDepartment
1AliceBrownPhysics
2DavidBlackChemistry

Assessments

AssessmentIDCourseIDAssessorIDAssessmentTypeIDScoreDate
(→ Courses.CourseID)(→ Professors.ProfessorID)(→ AssessmentTypes.TypeID)
1111852023-01-01 10:00:00
2121902023-01-01 11:00:00
3212752023-01-02 10:00:00
4222802023-01-02 11:00:00