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 |