Students

StudentIDFirstNameLastNameAge
1JohnDoe20
2JaneSmith23
3BobJohnson21
4AliceWilliams22
5TomBrown20

Courses

CourseIDTitleDepartment
1MathematicsMath
2PhysicsScience
3English LiteratureLanguages
4HistoryHumanities
5Computer ScienceTechnology

Enrollments

EnrollmentIDStudentIDCourseIDSemester
(→ Students.StudentID)(→ Courses.CourseID)
1112024-03-07 23:00:42
2222024-03-07 23:00:42
3332024-03-07 23:00:42
4442024-03-07 23:00:42
5552024-03-07 23:00:42

Assessments

AssessmentIDAssessmentMethodAssessorTotalMarksPassingMarkDateOfAssessment
(→ Students.FirstName)
1ExamProfessor Smith100602024-03-07 23:00:42
2ExamDr. Jones100652024-03-07 23:00:42
3QuizProfessor Smith20102024-03-07 23:00:42
4QuizDr. Brown20152024-03-07 23:00:42
5ProjectDr. Johnson100702024-03-07 23:00:42

Scores

ScoreIDEnrollmentIDAssessmentIDScore
(→ Enrollments.EnrollmentID)(→ Assessments.AssessmentID)
11180
21290
32185
42295
53175

Grades

GradeIDEnrollmentIDFinalGrade
(→ Enrollments.EnrollmentID)
11A
22B
33A
44B
55A