authors

author_idname
1William Shakespeare
2Jane Austen
3Charles Dickens
4Mark Twain
5Leo Tolstoy

genres

genre_idtype
1Drama
2Fantasy
3Romance
4Mystery
5Horror

comedies

comedy_idtitlegenre_idauthor_id
(→ genres.genre_id)(→ authors.author_id)
1A Midsummer Night's Dream11
2The Importance of Being Earnest22
3Pride and Prejudice33
4The Adventures of Tom Sawyer44
5War and Peace55

tragedies

tragedy_idtitlegenre_idauthor_id
(→ genres.genre_id)(→ authors.author_id)
1Romeo and Juliet61
2Macbeth71
3Persuasion83
4Great Expectations94
5Anna Karenina105

books

book_idtitlecomedy_idtragedy_idauthor_idgenre_id
(→ comedies.comedy_id)(→ tragedies.tragedy_id)(→ authors.author_id)(→ genres.genre_id)
1Casino RoyaleNoneNone611
2Harry Potter and the Philosopher's Stone1213714
3To Kill a Mockingbird1516817
4Crime and Punishment1819920
5Moby Dick21221023