authors

authorIDauthorName
1Author1
2Author2
3Author3
4Author4
5Author5

literaturetypes

literaturetypeIDtypeValuelanguageID
(→ languages.languageID)
1Novel1
2Essay2
3Play3
4Short Story4
5Non-Fiction5
6Novel1
7Novel2
8Poem1
9Poem3

books

bookIDtitlepublicationDateauthorIDliteraturetypeID
(→ authors.authorID)(→ literaturetypes.literaturetypeID)
1Book12001-06-0111
2Book22005-07-0122
3Book32008-09-0133
4Book42010-10-0144
5Book52012-11-0155

languages

languageIDlanguageValue
1Italian
2English
3Spanish
4German
5French