| author_id | name |
|---|---|
| 1 | William Shakespeare |
| 2 | Jane Austen |
| 3 | Charles Dickens |
| 4 | Mark Twain |
| 5 | Leo Tolstoy |
| genre_id | type |
|---|---|
| 1 | Drama |
| 2 | Fantasy |
| 3 | Romance |
| 4 | Mystery |
| 5 | Horror |
| 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 |
| 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 |
| 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 |