id | name | |
---|---|---|
1 | John Doe | john.doe@example.com |
2 | Jane Smith | jane.smith@example.com |
3 | Michael Johnson | michael.johnson@example.com |
4 | Emily Davis | emily.davis@example.com |
5 | David Brown | david.brown@example.com |
id | title | author_id |
---|---|---|
(→ Authors.id) | ||
1 | Introduction to Computer Science | 1 |
2 | Calculus for Engineers | 2 |
3 | General Chemistry | 3 |
4 | Organic Chemistry | 4 |
5 | Physics for Scientists and Engineers | 5 |
id | name | version_number | author_id |
---|---|---|---|
(→ Authors.id) | |||
1 | Microsoft Office | 2021 | 1 |
2 | Adobe Creative Suite | 2022 | 2 |
3 | Autodesk AutoCAD | 2022 | 3 |
4 | Oracle Database | 19c | 4 |
5 | Red Hat Enterprise Linux | 8.3 | 5 |
id | course_name | textbook_id | software_id |
---|---|---|---|
(→ Textbooks.id) | (→ Software.id) | ||
1 | Computer Science 101 | 1 | 1 |
2 | Engineering Mathematics | 2 | None |
3 | Introductory Organic Chemistry | 3 | 3 |
4 | Advanced Physics | 4 | 4 |
5 | Data Structures and Algorithms | 5 | 5 |
id | student_name | enrolled_course_id |
---|---|---|
(→ Courses.id) | ||
1 | Alice Smith | 1 |
2 | Bob Johnson | 2 |
3 | Carol Williams | 3 |
4 | Dave Brown | 4 |
5 | Eva Green | 5 |
id | grade | student_id | course_id |
---|---|---|---|
(→ Students.id) | (→ Courses.id) | ||
1 | 85 | 1 | 1 |
2 | 78 | 2 | 2 |
3 | 92 | 3 | 3 |
4 | 65 | 4 | 4 |
5 | 80 | 5 | 5 |