Directors
id | name |
1 | Alfred Hitchcock |
2 | Stanley Kubrick |
3 | Christopher Nolan |
4 | Quentin Tarantino |
5 | Martin Scorsese |
Actors
id | name |
1 | Leonardo DiCaprio |
2 | Meryl Streep |
3 | Tom Hanks |
4 | Jennifer Lawrence |
5 | Brad Pitt |
Genres
id | type |
1 | Drama |
2 | Action |
3 | Comedy |
4 | Horror |
5 | Thriller |
Roles
id | movieId | directorId | actorId |
| (→ Movies.id) | (→ Directors.id) | (→ Actors.id) |
1 | 1 | 1 | 1 |
2 | 2 | 1 | 2 |
3 | 3 | 2 | 3 |
4 | 4 | 3 | 4 |
5 | 5 | 4 | 5 |
Movies
id | title | dining_establishment | menu_options | genreID |
| | | | (→ Genres.id) |
1 | Inception | Restaurant | Vegetarian | 1 |
2 | The Shawshank Redemption | Restaurant | Non-vegetarian | 2 |
3 | Pulp Fiction | Cafe | Vegetarian | 3 |
4 | Forrest Gump | Cafe | Non-vegetarian | 4 |
5 | The Dark Knight | Bar | Vegetarian | 5 |