Publisher

idname
1Pearson
2Wiley
3McGraw-Hill
4Cengage Learning
5Elsevier

Textbooks

idtitlepublisherIdauthorprice
(→ Publisher.id)
1Calculus1Jones29.99
2Physics1Smith34.99
3Literature2Doe28.99
4History2Johnson30.99
5Biology3Brown32.99

EBooks

idtitlepublisherIdformatprice
(→ Publisher.id)
1Computer Science4EPUB27.99
2Mathematics4PDF26.99
3Engineering5EPUB25.99
4Philosophy5PDF24.99
5Art History3MOBI23.99

Subjects

idsubjectName
1Math
2Science
3English
4History
5Arts

BooksInSubject

bookIdsubjectId
(→ Textbooks.id)(→ Subjects.id)
11
22
33
44
55

Teachers

idfirstNamelastNamesubjectId
(→ Subjects.id)
1MichaelWilliams1
2EmmaJones2
3DavidMartin3
4LauraThompson4
5DanielGreen5