## Textbooks

id | Title | Subject | YearPublished | NumberOfPages | Publisher
--- | --- | --- | --- | --- | ---
1 | Introduction to Computer Science | Computer Science | 2019 | 300 | Pearson
2 | Physics for Scientists and Engineers | Physics | 2016 | 780 | Cambridge University Press

## EBooks

id | Title | Subject | SizeInMB | DownloadCount | Publisher
--- | --- | --- | --- | --- | ---
1 | The Great Gatsby | Literature | 5.0 | 1200 | Pearson
2 | A Brief History of Time | Science | 2.5 | 800 | Houghton Mifflin Harcourt

## Students

id | Name | Age | GradeLevel
--- | --- | --- | ---
1 | John Doe | 21 | 3
2 | Jane Smith | 20 | 4

## Exams

id | Date | Score | StudentId
--- | --- | --- | ---
|  |  | (→ Students.id)
1 | 2021-01-01 10:00:00 | 85 | 1
2 | 2021-02-01 10:00:00 | 90 | 2

## ReadingLists

id | StudentId | BookType | BookId | READING_DATE
--- | --- | --- | --- | ---
| (→ Students.id) |  | (→ Books.id) |
1 | 1 | Textbook | 1 | 2021-01-01 10:00:00
2 | 2 | E_book | 2 | 2021-02-01 10:00:00

## Books

id | Title | Author | ISBN
--- | --- | --- | ---
1 | To Kill a Mockingbird | Harper Lee | 978-0-06-093546-7
2 | 1984 | George Orwell | 978-0-451-52493-5