| id | name |
|---|---|
| 1 | Mathematics |
| 2 | Physics |
| 3 | Chemistry |
| 4 | Biology |
| 5 | Computer Science |
| id | firstname | lastname | |
|---|---|---|---|
| 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 |
| id | firstname | lastname | |
|---|---|---|---|
| 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 |
| id | student_id | course_id |
|---|---|---|
| (→ Students.id) | (→ Courses.id) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | 3 |
| 4 | 4 | 4 |
| 5 | 5 | 5 |
| id | enrollment_id | grade |
|---|---|---|
| (→ Enrollments.id) | ||
| 1 | 1 | A+ |
| 2 | 2 | B- |
| 3 | 3 | A |
| 4 | 4 | B+ |
| 5 | 5 | A |
| id | Teaching_Subject | professor_id |
|---|---|---|
| (→ Disciplines.id) | (→ Professors.id) | |
| 1 | 1 | 1 |
| 2 | 2 | 3 |
| 3 | 3 | 2 |
| 4 | 4 | 4 |
| 5 | 5 | 5 |