## Genre

ID | Name
--- | ---
1 | Fiction
2 | Nonfiction
3 | Mystery
4 | Science Fiction
5 | Adventure

## AgeGroup

ID | GroupName
--- | ---
1 | Children's Book
2 | Young Adult Book
3 | Teenage Book
4 | Adult Book
5 | Older Readers Book

## Author

ID | FirstName | LastName | Biography
--- | --- | --- | ---
1 | John | Doe | He is a famous author.
2 | Jane | Smith | She is an illustrator.
3 | Emily | Brown | She writes science fiction novels.
4 | Michael | White | He has written many mystery books.
5 | Linda | Green | She writes adventure stories.

## Illustrator

ID | Fullname
--- | ---
1 | Jane Smith
2 | Robert Johnson
3 | William Brown
4 | David White
5 | Mark Green

## Publisher

ID | CompanyName | Address | PhoneNumber
--- | --- | --- | ---
1 | Random House | New York, USA | +1 212-598-6000
2 | HarperCollins | London, UK | +44 207-867-8000
3 | Macmillan Publishers | Berlin, Germany | +49 30-260-00-0
4 | Simon & Schuster | New York, USA | +1 212-698-7000
5 | Hachette Book Group | Paris, France | +33 1-55-62-20-00

## Books

ID | Title | Summary | ReleaseDate | Price | GenreID | AgeGroupID | AuthorID | IllustratorID | PublisherID
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Genre.ID) | (→ AgeGroup.ID) | (→ Author.ID) | (→ Illustrator.ID) | (→ Publisher.ID)
1 | Book A | Summary of book A. | 2021-01-01 | 9.99 | 1 | 1 | 1 | 1 | 1
2 | Book B | Summary of book B. | 2021-02-01 | 12.99 | 2 | 1 | 2 | 1 | 2
3 | Book C | Summary of book C. | 2021-03-01 | 14.99 | 3 | 2 | 3 | 2 | 3
4 | Book D | Summary of book D. | 2021-04-01 | 10.99 | 4 | 1 | 4 | 1 | 4
5 | Book E | Summary of book E. | 2021-05-01 | 11.99 | 5 | 2 | 5 | 1 | 5