| id | first_name | last_name |
|---|---|---|
| 1 | Fyodor | Dostoyevsky |
| 2 | William | Gibson |
| 3 | Neal | Stephenson |
| 4 | Arthur Conan | Doyle |
| 5 | Arkady | Strugatsky |
| id | author_id | title |
|---|---|---|
| 1 | 1 | The Gambler |
| 2 | 1 | Crime and Punishment |
| 3 | 2 | Neuromancer |
| 4 | 4 | The Sign of Four |
| 5 | 4 | The Adventures of Sherlock Holmes |
| 6 | None | Voynich Manuscript |
| 7 | 1 | The House of the Dead |