## 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