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 |