Students

StudentIDFirstNameLastNameBirthDateMajor
1JohnDoe1998-06-15Computer Science
2JaneSmith2000-03-25Mathematics
3AliceBrown1997-11-10Physics
4BobWhite1999-07-22Chemistry
5CharlieGreen2001-04-05Biology
6DavidBlack1996-12-18English Literature

Assessors

AssessorIDNameTitleDepartment
1Professor SmithAssociate ProfessorLiterature
2Dr. JohnsonFull ProfessorHistory
3Ms. WilliamsAssistant ProfessorPolitical Science
4Mr. LeeAdjunct InstructorEconomics
5Dr. JacksonAssociate ProfessorPhilosophy

Exams

ExamIDCourseTitleTotalMarksPassingMarkAssessorId
(→ Assessors.AssessorID)
1Introduction to English Literature100601
2World History100602
3American Politics100603
4Macroeconomic Theory100604
5Contemporary Ethics100605

Quizzes

QuizIDDescriptionMaxScoreMinPassingScoreAssessorId
(→ Assessors.AssessorID)
1Weekly quiz on literary themes20121
2Midterm exam review questions30202
3Current events analysis20123
4Final exam study guide30204
5Argumentative essay practice20125