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 |