## Formats

id | name
--- | ---
1 | Paperback
2 | Hardcover
3 | Ebook
4 | Audiobook
5 | Digital

## Books

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

## Authors

id | firstname | lastname
--- | --- | ---
1 | Jane | Austen
2 | Charles | Dickens
3 | Leo | Tolstoy
4 | Mark | Twain
5 | George | Orwell

## Books_Authors

book_id | author_id
--- | ---
(→ Books.id) | (→ Authors.id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5

## Book_Formats

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