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 |