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 |