| 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 |