## authors

author_id | name
--- | ---
1 | William Shakespeare
2 | Jane Austen
3 | Charles Dickens
4 | Mark Twain
5 | Leo Tolstoy

## genres

genre_id | type
--- | ---
1 | Drama
2 | Fantasy
3 | Romance
4 | Mystery
5 | Horror

## comedies

comedy_id | title | genre_id | author_id
--- | --- | --- | ---
|  | (→ genres.genre_id) | (→ authors.author_id)
1 | A Midsummer Night's Dream | 1 | 1
2 | The Importance of Being Earnest | 2 | 2
3 | Pride and Prejudice | 3 | 3
4 | The Adventures of Tom Sawyer | 4 | 4
5 | War and Peace | 5 | 5

## tragedies

tragedy_id | title | genre_id | author_id
--- | --- | --- | ---
|  | (→ genres.genre_id) | (→ authors.author_id)
1 | Romeo and Juliet | 6 | 1
2 | Macbeth | 7 | 1
3 | Persuasion | 8 | 3
4 | Great Expectations | 9 | 4
5 | Anna Karenina | 10 | 5

## books

book_id | title | comedy_id | tragedy_id | author_id | genre_id
--- | --- | --- | --- | --- | ---
|  | (→ comedies.comedy_id) | (→ tragedies.tragedy_id) | (→ authors.author_id) | (→ genres.genre_id)
1 | Casino Royale | None | None | 6 | 11
2 | Harry Potter and the Philosopher's Stone | 12 | 13 | 7 | 14
3 | To Kill a Mockingbird | 15 | 16 | 8 | 17
4 | Crime and Punishment | 18 | 19 | 9 | 20
5 | Moby Dick | 21 | 22 | 10 | 23