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 |