## Movie_Genres

id | genre_name | description
--- | --- | ---
1 | Action | High-paced action movies
2 | Drama | Emotional stories that focus on character development
3 | Comedy | Humorous films designed to entertain
4 | Horror | Films that evoke fear or terror
5 | Romance | Stories centered around love relationships

## Tropes

id | trope_value | description
--- | --- | ---
1 | Love_Triangle | A romantic story involving three people who are involved with one another
2 | Destiny | The belief that certain events are predestined to happen
3 | Amnesia | A character loses their memory and struggles to regain it
4 | Redemption | A character seeks redemption from past mistakes
5 | Time_Travel | Characters travel back in time or to an alternate timeline

## Movie_Genres_Tropes

movie_genre_id | trope_id
--- | ---
(→ Movie_Genres.id) | (→ Tropes.id)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1

## Movies

id | title | release_year | director | country
--- | --- | --- | --- | ---
1 | Inception | 2010 | Christopher Nolan | USA
2 | Pulp Fiction | 1994 | Quentin Tarantino | USA
3 | Forrest Gump | 1994 | Robert Zemeckis | USA
4 | Eternal Sunshine of the Spotless Mind | 2004 | Michel Gondry | USA
5 | La La Land | 2016 | Damien Chazelle | USA

## Actors

id | name | birthdate | nationality
--- | --- | --- | ---
1 | Leonardo DiCaprio | 1974-11-11 | American
2 | Brad Pitt | 1963-12-18 | American
3 | Tom Hanks | 1956-07-09 | American
4 | Julie Andrews | 1935-10-01 | English
5 | Cate Blanchett | 1969-05-14 | Australian

## Movie_Actors

movie_id | actor_id | role
--- | --- | ---
(→ Movies.id) | (→ Actors.id) |
1 | 1 | Cobb
1 | 2 | Arthur
2 | 1 | Vincent Vega
2 | 3 | Edward Lewis
3 | 4 | Lorenzo Musetti