Textbooks

idTitleSubjectYearPublishedNumberOfPagesPublisher
1Introduction to Computer ScienceComputer Science2019300Pearson
2Physics for Scientists and EngineersPhysics2016780Cambridge University Press

EBooks

idTitleSubjectSizeInMBDownloadCountPublisher
1The Great GatsbyLiterature5.01200Pearson
2A Brief History of TimeScience2.5800Houghton Mifflin Harcourt

Students

idNameAgeGradeLevel
1John Doe213
2Jane Smith204

Exams

idDateScoreStudentId
(→ Students.id)
12021-01-01 10:00:00851
22021-02-01 10:00:00902

ReadingLists

idStudentIdBookTypeBookIdREADING_DATE
(→ Students.id)(→ Books.id)
11Textbook12021-01-01 10:00:00
22E_book22021-02-01 10:00:00

Books

idTitleAuthorISBN
1To Kill a MockingbirdHarper Lee978-0-06-093546-7
21984George Orwell978-0-451-52493-5