Authors

idnameemail
1John Doejohn.doe@example.com
2Jane Smithjane.smith@example.com
3Michael Johnsonmichael.johnson@example.com
4Emily Davisemily.davis@example.com
5David Browndavid.brown@example.com

Textbooks

idtitleauthor_id
(→ Authors.id)
1Introduction to Computer Science1
2Calculus for Engineers2
3General Chemistry3
4Organic Chemistry4
5Physics for Scientists and Engineers5

Software

idnameversion_numberauthor_id
(→ Authors.id)
1Microsoft Office20211
2Adobe Creative Suite20222
3Autodesk AutoCAD20223
4Oracle Database19c4
5Red Hat Enterprise Linux8.35

Courses

idcourse_nametextbook_idsoftware_id
(→ Textbooks.id)(→ Software.id)
1Computer Science 10111
2Engineering Mathematics2None
3Introductory Organic Chemistry33
4Advanced Physics44
5Data Structures and Algorithms55

Students

idstudent_nameenrolled_course_id
(→ Courses.id)
1Alice Smith1
2Bob Johnson2
3Carol Williams3
4Dave Brown4
5Eva Green5

Grades

idgradestudent_idcourse_id
(→ Students.id)(→ Courses.id)
18511
27822
39233
46544
58055