Authors

idname
1Jane Austen
2Charles Dickens
3George Orwell
4Fyodor Dostoevsky
5Gabriel Garcia Marquez

Genre_Types

idgenre_name
1Drama
2Mystery
3Romance
4Science Fiction
5Horror

Books

idtitleauthor_idgenre_type_id
(→ Authors.id)(→ Genre_types.id)
1Pride and Prejudice13
2A Tale of Two Cities21
3Animal Farm35
4Crime and Punishment44
5One Hundred Years of Solitude56

Comedy

idbook_idcomedy_elements
(→ Books.id)
11Humorous dialogue
22Slapstick humor
33Witty satire
44Character-driven humor
55Cultural references

Tragedy

idbook_idtragedy_elements
(→ Books.id)
11Death of a loved one
22Downfall of a hero
33Betrayal by friends
44Unattainable love
55Corruption of innocence

Reviews

idbook_idreviewer_nameratingcomments
(→ Books.id)
11Alice Smith9Excellent character development.
21Bob Johnson8Loved it! Classic literature.
32Carol Williams7It was good but not as great as I expected.
42David Brown6Not my cup of tea.
53Eva Green10Absolutely amazing.