## 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