## Students

StudentID | FirstName | LastName | Age
--- | --- | --- | ---
1 | John | Doe | 20
2 | Jane | Smith | 23
3 | Bob | Johnson | 21
4 | Alice | Williams | 22
5 | Tom | Brown | 20

## Courses

CourseID | Title | Department
--- | --- | ---
1 | Mathematics | Math
2 | Physics | Science
3 | English Literature | Languages
4 | History | Humanities
5 | Computer Science | Technology

## Enrollments

EnrollmentID | StudentID | CourseID | Semester
--- | --- | --- | ---
| (→ Students.StudentID) | (→ Courses.CourseID) |
1 | 1 | 1 | 2024-03-07 23:00:42
2 | 2 | 2 | 2024-03-07 23:00:42
3 | 3 | 3 | 2024-03-07 23:00:42
4 | 4 | 4 | 2024-03-07 23:00:42
5 | 5 | 5 | 2024-03-07 23:00:42

## Assessments

AssessmentID | AssessmentMethod | Assessor | TotalMarks | PassingMark | DateOfAssessment
--- | --- | --- | --- | --- | ---
|  | (→ Students.FirstName) |  |  |
1 | Exam | Professor Smith | 100 | 60 | 2024-03-07 23:00:42
2 | Exam | Dr. Jones | 100 | 65 | 2024-03-07 23:00:42
3 | Quiz | Professor Smith | 20 | 10 | 2024-03-07 23:00:42
4 | Quiz | Dr. Brown | 20 | 15 | 2024-03-07 23:00:42
5 | Project | Dr. Johnson | 100 | 70 | 2024-03-07 23:00:42

## Scores

ScoreID | EnrollmentID | AssessmentID | Score
--- | --- | --- | ---
| (→ Enrollments.EnrollmentID) | (→ Assessments.AssessmentID) |
1 | 1 | 1 | 80
2 | 1 | 2 | 90
3 | 2 | 1 | 85
4 | 2 | 2 | 95
5 | 3 | 1 | 75

## Grades

GradeID | EnrollmentID | FinalGrade
--- | --- | ---
| (→ Enrollments.EnrollmentID) |
1 | 1 | A
2 | 2 | B
3 | 3 | A
4 | 4 | B
5 | 5 | A