Language
| id | language_name |
| 1 | Italian |
| 2 | French |
Novels
| id | title | author_id | genre_id | language_id |
| | (→ Authors.id) | (→ Genres.id) | (→ Language.id) |
| 1 | The Great Gatsby | 1 | 1 | 1 |
| 2 | War And Peace | 2 | 2 | 2 |
Poems
| id | title | poet_id | theme_id | language_id |
| | (→ Poets.id) | (→ Themes.id) | (→ Language.id) |
| 1 | Ode To Joy | 1 | 1 | 1 |
| 2 | La Vita Nuova | 2 | 2 | 2 |
Authors
| id | name |
| 1 | Mark Twain |
| 2 | Leo Tolstoy |
Genres
| id | genre_name |
| 1 | Romance |
| 2 | Adventure |
Themes
| id | theme_name |
| 1 | Love |
| 2 | Exploration |
Actors
| id | name |
| 1 | Tom Hanks |
| 2 | Julia Roberts |
Movies
| id | movie_title | release_year | director_id | actor_id | genre_id |
| | | (→ Directors.id) | (→ Actors.id) | (→ Genres.id) |
| 1 | Forrest Gump | 1994 | 2 | 3 | 2 |
| 2 | Gone With The Wind | 1939 | 1 | 2 | 1 |
Directors
| id | name |
| 1 | Robert Zemeckis |
| 2 | Victor Fleming |