## Categories

id | categoryName
--- | ---
1 | Fantasy
2 | Horror

## Films

id | title | budget | categoryId
--- | --- | --- | ---
|  |  | (→ Categories.id)
1 | Lord of the Rings | 20000000.0 | 1
2 | Harry Potter | 30000000.0 | 1
3 | The Shining | 20000000.0 | 2
4 | It | 18000000.0 | 2

## Actors

id | firstName | lastName
--- | --- | ---
1 | Leonardo | DiCaprio
2 | Meryl | Streep

## Directors

id | directorName
--- | ---
1 | Peter Jackson
2 | Christopher Nolan

## Roles

filmId | actorId | roleType | directorId
--- | --- | --- | ---
(→ Films.id) | (→ Actors.id) |  | (→ Directors.id)
1 | 1 | Leading Role | 1
2 | 2 | Supporting Role | 2
1 | 2 | Villain | 1
3 | 1 | Leading Role | 1
4 | 2 | Supporting Role | 2