## Authors

id | name | email
--- | --- | ---
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

## Textbooks

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

## Software

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

## Courses

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

## Students

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

## Grades

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