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