## Movie

id | title | releaseDate | Crime_Fiction | Studio | directorId
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Director.id)
1 | MovieA | 2000-01-01 | Mystery | Warner Bros | 1
2 | MovieB | 2000-01-01 | Mystery | Universal Studios | 2
3 | MovieC | 2000-01-01 | Thriller | Warner Bros | 3
4 | MovieD | 2000-01-01 | Thriller | Disney | 4
5 | MovieE | 2000-01-01 | Comedy | Columbia Pictures | 5

## Director

id | name | birthYear
--- | --- | ---
1 | John Doe | 1960
2 | Jane Smith | 1972
3 | Alice Brown | 1983
4 | Robert Johnson | 1990
5 | Emma Wilson | 1995

## Actor

id | firstName | lastName | dateOfBirth
--- | --- | --- | ---
1 | Tom | Hanks | 1956-07-09
2 | Denzel | Washington | 1954-12-28
3 | Scarlett | Johansson | 1984-11-22
4 | Leonardo | DiCaprio | 1974-11-11
5 | Mark | Ruffalo | 1967-11-22

## Cast

movieId | actorId | role
--- | --- | ---
(→ Movie.id) | (→ Actor.id) |
1 | 1 | Lead Role
1 | 2 | Supporting Role
2 | 3 | Lead Role
2 | 4 | Supporting Role
3 | 5 | Lead Role
3 | 6 | Supporting Role

## Genre

id | genreText
--- | ---
1 | Action
2 | Adventure
3 | Drama
4 | Family
5 | Fantasy

## MovieGenre

movieId | genreId
--- | ---
(→ Movie.id) | (→ Genre.id)
1 | 1
1 | 2
2 | 3
3 | 4
4 | 5