Genre

IDName
1Fiction
2Nonfiction
3Mystery
4Science Fiction
5Adventure

AgeGroup

IDGroupName
1Children's Book
2Young Adult Book
3Teenage Book
4Adult Book
5Older Readers Book

Author

IDFirstNameLastNameBiography
1JohnDoeHe is a famous author.
2JaneSmithShe is an illustrator.
3EmilyBrownShe writes science fiction novels.
4MichaelWhiteHe has written many mystery books.
5LindaGreenShe writes adventure stories.

Illustrator

IDFullname
1Jane Smith
2Robert Johnson
3William Brown
4David White
5Mark Green

Publisher

IDCompanyNameAddressPhoneNumber
1Random HouseNew York, USA+1 212-598-6000
2HarperCollinsLondon, UK+44 207-867-8000
3Macmillan PublishersBerlin, Germany+49 30-260-00-0
4Simon & SchusterNew York, USA+1 212-698-7000
5Hachette Book GroupParis, France+33 1-55-62-20-00

Books

IDTitleSummaryReleaseDatePriceGenreIDAgeGroupIDAuthorIDIllustratorIDPublisherID
(→ Genre.ID)(→ AgeGroup.ID)(→ Author.ID)(→ Illustrator.ID)(→ Publisher.ID)
1Book ASummary of book A.2021-01-019.9911111
2Book BSummary of book B.2021-02-0112.9921212
3Book CSummary of book C.2021-03-0114.9932323
4Book DSummary of book D.2021-04-0110.9941414
5Book ESummary of book E.2021-05-0111.9952515