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 |
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 |
id | Name | Age | GradeLevel |
---|---|---|---|
1 | John Doe | 21 | 3 |
2 | Jane Smith | 20 | 4 |
id | Date | Score | StudentId |
---|---|---|---|
(→ Students.id) | |||
1 | 2021-01-01 10:00:00 | 85 | 1 |
2 | 2021-02-01 10:00:00 | 90 | 2 |
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 |
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 |