Publisher
| id | name |
| 1 | Pearson |
| 2 | Wiley |
| 3 | McGraw-Hill |
| 4 | Cengage Learning |
| 5 | Elsevier |
Textbooks
| id | title | publisherId | author | price |
| | (→ Publisher.id) | | |
| 1 | Calculus | 1 | Jones | 29.99 |
| 2 | Physics | 1 | Smith | 34.99 |
| 3 | Literature | 2 | Doe | 28.99 |
| 4 | History | 2 | Johnson | 30.99 |
| 5 | Biology | 3 | Brown | 32.99 |
EBooks
| id | title | publisherId | format | price |
| | (→ Publisher.id) | | |
| 1 | Computer Science | 4 | EPUB | 27.99 |
| 2 | Mathematics | 4 | PDF | 26.99 |
| 3 | Engineering | 5 | EPUB | 25.99 |
| 4 | Philosophy | 5 | PDF | 24.99 |
| 5 | Art History | 3 | MOBI | 23.99 |
Subjects
| id | subjectName |
| 1 | Math |
| 2 | Science |
| 3 | English |
| 4 | History |
| 5 | Arts |
BooksInSubject
| bookId | subjectId |
| (→ Textbooks.id) | (→ Subjects.id) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |
Teachers
| id | firstName | lastName | subjectId |
| | | (→ Subjects.id) |
| 1 | Michael | Williams | 1 |
| 2 | Emma | Jones | 2 |
| 3 | David | Martin | 3 |
| 4 | Laura | Thompson | 4 |
| 5 | Daniel | Green | 5 |