Author
| id | name |
| 1 | John Doe |
| 2 | Jane Smith |
| 3 | Michael Johnson |
| 4 | Emily Davis |
| 5 | Robert Brown |
Publisher
| id | name |
| 1 | ABC Publishers |
| 2 | XYZ Publishers |
| 3 | PQR Publishers |
| 4 | LMN Publishers |
| 5 | STU Publishers |
Genre
| id | genre_name |
| 1 | Fantasy |
| 2 | Romance |
| 3 | Thriller |
| 4 | Horror |
| 5 | Historical Fiction |
Character
| id | character_name |
| 1 | Alice |
| 2 | Bob |
| 3 | Charlie |
| 4 | David |
| 5 | Eve |
Book
| id | title | age_group | illustrator | author_id | publisher_id | genre_id | main_character_id |
| | | | (→ Author.id) | (→ Publisher.id) | (→ Genre.id) | (→ Character.id) |
| 1 | The Enchanted Forest | Children's Book | Jane Smith | 1 | 2 | 3 | 1 |
| 2 | Adventures of Tom Sawyer | Children's Book | Mark Twain | 2 | 3 | 4 | 2 |
| 3 | Gone With The Wind | Young Adult Book | Jane Smith | 3 | 4 | 5 | 3 |
| 4 | To Kill A Mockingbird | Young Adult Book | Harper Lee | 4 | 5 | 6 | 4 |
| 5 | 1984 | General | George Orwell | 5 | 1 | 7 | 5 |