| id | name |
|---|---|
| 1 | Paperback |
| 2 | Hardcover |
| 3 | Ebook |
| 4 | Audiobook |
| 5 | Digital |
| id | title | author |
|---|---|---|
| 1 | Pride and Prejudice | Jane Austen |
| 2 | Great Expectations | Charles Dickens |
| 3 | War and Peace | Leo Tolstoy |
| 4 | The Adventures of Huckleberry Finn | Mark Twain |
| 5 | 1984 | George Orwell |
| id | firstname | lastname |
|---|---|---|
| 1 | Jane | Austen |
| 2 | Charles | Dickens |
| 3 | Leo | Tolstoy |
| 4 | Mark | Twain |
| 5 | George | Orwell |
| book_id | author_id |
|---|---|
| (→ Books.id) | (→ Authors.id) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |
| book_id | format_id |
|---|---|
| (→ Books.id) | (→ Formats.id) |
| 1 | 1 |
| 1 | 2 |
| 2 | 1 |
| 2 | 3 |
| 3 | 1 |
| 3 | 4 |
| 4 | 1 |
| 4 | 5 |
| 5 | 2 |
| 5 | 1 |