## authors

authorID | authorName
--- | ---
1 | Author1
2 | Author2
3 | Author3
4 | Author4
5 | Author5

## literaturetypes

literaturetypeID | typeValue | languageID
--- | --- | ---
|  | (→ languages.languageID)
1 | Novel | 1
2 | Essay | 2
3 | Play | 3
4 | Short Story | 4
5 | Non-Fiction | 5
6 | Novel | 1
7 | Novel | 2
8 | Poem | 1
9 | Poem | 3

## books

bookID | title | publicationDate | authorID | literaturetypeID
--- | --- | --- | --- | ---
|  |  | (→ authors.authorID) | (→ literaturetypes.literaturetypeID)
1 | Book1 | 2001-06-01 | 1 | 1
2 | Book2 | 2005-07-01 | 2 | 2
3 | Book3 | 2008-09-01 | 3 | 3
4 | Book4 | 2010-10-01 | 4 | 4
5 | Book5 | 2012-11-01 | 5 | 5

## languages

languageID | languageValue
--- | ---
1 | Italian
2 | English
3 | Spanish
4 | German
5 | French