Students

idnameage
1Alice20
2Bob21
3Charlie22
4David23
5Eva24

Exams

idstudent_idmarks
(→ Students.id)
1185
2290
3375
4465
5580

Quizzes

idstudent_idpoints
(→ Students.id)
1170
2285
3360
4455
5575

Assessors

idname
1Professor Smith
2Dr. Johnson
3Ms. Brown
4Mr. White
5Mrs. Green

Subjects

idsubject_nameassessor_id
(→ Assessors.id)
1Mathematics1
2Physics2
3Chemistry3
4Biology4
5History5

StudentSubjects

student_idsubject_id
(→ Students.id)(→ Subjects.id)
11
22
33
44
55