Formats

idname
1Paperback
2Hardcover
3Ebook
4Audiobook
5Digital

Books

idtitleauthor
1Pride and PrejudiceJane Austen
2Great ExpectationsCharles Dickens
3War and PeaceLeo Tolstoy
4The Adventures of Huckleberry FinnMark Twain
51984George Orwell

Authors

idfirstnamelastname
1JaneAusten
2CharlesDickens
3LeoTolstoy
4MarkTwain
5GeorgeOrwell

Books_Authors

book_idauthor_id
(→ Books.id)(→ Authors.id)
11
22
33
44
55

Book_Formats

book_idformat_id
(→ Books.id)(→ Formats.id)
11
12
21
23
31
34
41
45
52
51