## Disciplines

id | name
--- | ---
1 | Mathematics
2 | Physics
3 | Chemistry
4 | Biology
5 | Computer Science

## Professors

id | firstname | lastname | email
--- | --- | --- | ---
1 | John | Doe | john.doe@example.com
2 | Jane | Smith | jane.smith@example.com
3 | Michael | Johnson | michael.johnson@example.com
4 | Emily | Williams | emily.williams@example.com
5 | David | Brown | david.brown@example.com

## Students

id | firstname | lastname | email
--- | --- | --- | ---
1 | Tom | Robertson | tom.robertson@example.com
2 | Lucy | Taylor | lucy.taylor@example.com
3 | Chris | Wilson | chris.wilson@example.com
4 | Alice | Thompson | alice.thompson@example.com
5 | Daniel | Jackson | daniel.jackson@example.com

## Enrollments

id | student_id | course_id
--- | --- | ---
| (→ Students.id) | (→ Courses.id)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3
4 | 4 | 4
5 | 5 | 5

## Grades

id | enrollment_id | grade
--- | --- | ---
| (→ Enrollments.id) |
1 | 1 | A+
2 | 2 | B-
3 | 3 | A
4 | 4 | B+
5 | 5 | A

## Courses

id | Teaching_Subject | professor_id
--- | --- | ---
| (→ Disciplines.id) | (→ Professors.id)
1 | 1 | 1
2 | 2 | 3
3 | 3 | 2
4 | 4 | 4
5 | 5 | 5