## Film_Archivists

id | name | email
--- | --- | ---
1 | John Doe | john@example.com
2 | Jane Smith | jane@example.com
3 | Michael Johnson | michael@example.com

## Preservation_Methods

id | method | description
--- | --- | ---
1 | Film Negatives | Storing physical copies of films on celluloid.
2 | Digital Files | Storing digital copies of films on hard drives or cloud storage.
3 | Blu-ray Discs | Storing high definition video on Blu-ray discs.
4 | DVDs | Storing standard definition video on DVDs.

## Films

id | title | year
--- | --- | ---
1 | The Shawshank Redemption | 1994.0
2 | The Godfather | 1972.0
3 | Pulp Fiction | 1994.0
4 | Schindler's List | 1993.0
5 | Forrest Gump | 1994.0

## Archived_Films

film_id | archiver_id | preservation_method_id
--- | --- | ---
(→ Films.id) | (→ Film_Archivists.id) | (→ Preservation_Methods.id)
None | 1 | 1
None | 2 | 1
None | 3 | 1
None | 3 | 1

## Director

director_id | firstname | lastname
--- | --- | ---
1 | Frank | Darabont
2 | Mario | Puzo
3 | Quentin | Tarantino
4 | Steven | Spielberg
5 | Robert | Zemeckis

## Producer

producer_id | firstname | lastname
--- | --- | ---
1 | Albert | Ruddy
2 | Gordon | Carroll
3 | Barry | Winkler
4 | Joel | Silver
5 | Mark | Harrison

## Actor

actor_id | firstname | lastname
--- | --- | ---
1 | Tim | Robin
2 | Marlon | Brando
3 | Brad | Pitt
4 | Tom | Hanks
5 | Jack | Nicholson

## Roles

role_id | film_id | director_id | producer_id | actor_id
--- | --- | --- | --- | ---
| (→ Films.id) | (→ Director.director_id) | (→ Producer.producer_id) | (→ Actor.actor_id)
1 | 1 | 2 | 3 | 4
2 | 2 | 1 | 4 | 5
3 | 3 | 6 | 5 | 7
4 | 4 | 8 | 7 | 8
5 | 5 | 9 | 8 | 9