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 |