id | name |
---|---|
1 | Jane Austen |
2 | Charles Dickens |
3 | George Orwell |
4 | Fyodor Dostoevsky |
5 | Gabriel Garcia Marquez |
id | genre_name |
---|---|
1 | Drama |
2 | Mystery |
3 | Romance |
4 | Science Fiction |
5 | Horror |
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 |
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 |
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 |
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. |