## Students

StudentID | FirstName | LastName | BirthDate | Major
--- | --- | --- | --- | ---
1 | John | Doe | 1998-06-15 | Computer Science
2 | Jane | Smith | 2000-03-25 | Mathematics
3 | Alice | Brown | 1997-11-10 | Physics
4 | Bob | White | 1999-07-22 | Chemistry
5 | Charlie | Green | 2001-04-05 | Biology
6 | David | Black | 1996-12-18 | English Literature

## Assessors

AssessorID | Name | Title | Department
--- | --- | --- | ---
1 | Professor Smith | Associate Professor | Literature
2 | Dr. Johnson | Full Professor | History
3 | Ms. Williams | Assistant Professor | Political Science
4 | Mr. Lee | Adjunct Instructor | Economics
5 | Dr. Jackson | Associate Professor | Philosophy

## Exams

ExamID | CourseTitle | TotalMarks | PassingMark | AssessorId
--- | --- | --- | --- | ---
|  |  |  | (→ Assessors.AssessorID)
1 | Introduction to English Literature | 100 | 60 | 1
2 | World History | 100 | 60 | 2
3 | American Politics | 100 | 60 | 3
4 | Macroeconomic Theory | 100 | 60 | 4
5 | Contemporary Ethics | 100 | 60 | 5

## Quizzes

QuizID | Description | MaxScore | MinPassingScore | AssessorId
--- | --- | --- | --- | ---
|  |  |  | (→ Assessors.AssessorID)
1 | Weekly quiz on literary themes | 20 | 12 | 1
2 | Midterm exam review questions | 30 | 20 | 2
3 | Current events analysis | 20 | 12 | 3
4 | Final exam study guide | 30 | 20 | 4
5 | Argumentative essay practice | 20 | 12 | 5