## Authors

id | name
--- | ---
1 | Jane Austen
2 | Charles Dickens
3 | George Orwell
4 | Fyodor Dostoevsky
5 | Gabriel Garcia Marquez

## Genre_Types

id | genre_name
--- | ---
1 | Drama
2 | Mystery
3 | Romance
4 | Science Fiction
5 | Horror

## Books

id | title | author_id | genre_type_id
--- | --- | --- | ---
|  | (→ Authors.id) | (→ Genre_types.id)
1 | Pride and Prejudice | 1 | 3
2 | A Tale of Two Cities | 2 | 1
3 | Animal Farm | 3 | 5
4 | Crime and Punishment | 4 | 4
5 | One Hundred Years of Solitude | 5 | 6

## Comedy

id | book_id | comedy_elements
--- | --- | ---
| (→ Books.id) |
1 | 1 | Humorous dialogue
2 | 2 | Slapstick humor
3 | 3 | Witty satire
4 | 4 | Character-driven humor
5 | 5 | Cultural references

## Tragedy

id | book_id | tragedy_elements
--- | --- | ---
| (→ Books.id) |
1 | 1 | Death of a loved one
2 | 2 | Downfall of a hero
3 | 3 | Betrayal by friends
4 | 4 | Unattainable love
5 | 5 | Corruption of innocence

## Reviews

id | book_id | reviewer_name | rating | comments
--- | --- | --- | --- | ---
| (→ Books.id) |  |  |
1 | 1 | Alice Smith | 9 | Excellent character development.
2 | 1 | Bob Johnson | 8 | Loved it! Classic literature.
3 | 2 | Carol Williams | 7 | It was good but not as great as I expected.
4 | 2 | David Brown | 6 | Not my cup of tea.
5 | 3 | Eva Green | 10 | Absolutely amazing.