Disciplines

idname
1Mathematics
2Physics
3Chemistry
4Biology
5Computer Science

Professors

idfirstnamelastnameemail
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com
3MichaelJohnsonmichael.johnson@example.com
4EmilyWilliamsemily.williams@example.com
5DavidBrowndavid.brown@example.com

Students

idfirstnamelastnameemail
1TomRobertsontom.robertson@example.com
2LucyTaylorlucy.taylor@example.com
3ChrisWilsonchris.wilson@example.com
4AliceThompsonalice.thompson@example.com
5DanielJacksondaniel.jackson@example.com

Enrollments

idstudent_idcourse_id
(→ Students.id)(→ Courses.id)
111
222
333
444
555

Grades

idenrollment_idgrade
(→ Enrollments.id)
11A+
22B-
33A
44B+
55A

Courses

idTeaching_Subjectprofessor_id
(→ Disciplines.id)(→ Professors.id)
111
223
332
444
555