Film_Archivists

idnameemail
1John Doejohn@example.com
2Jane Smithjane@example.com
3Michael Johnsonmichael@example.com

Preservation_Methods

idmethoddescription
1Film NegativesStoring physical copies of films on celluloid.
2Digital FilesStoring digital copies of films on hard drives or cloud storage.
3Blu-ray DiscsStoring high definition video on Blu-ray discs.
4DVDsStoring standard definition video on DVDs.

Films

idtitleyear
1The Shawshank Redemption1994.0
2The Godfather1972.0
3Pulp Fiction1994.0
4Schindler's List1993.0
5Forrest Gump1994.0

Archived_Films

film_idarchiver_idpreservation_method_id
(→ Films.id)(→ Film_Archivists.id)(→ Preservation_Methods.id)
None11
None21
None31
None31

Director

director_idfirstnamelastname
1FrankDarabont
2MarioPuzo
3QuentinTarantino
4StevenSpielberg
5RobertZemeckis

Producer

producer_idfirstnamelastname
1AlbertRuddy
2GordonCarroll
3BarryWinkler
4JoelSilver
5MarkHarrison

Actor

actor_idfirstnamelastname
1TimRobin
2MarlonBrando
3BradPitt
4TomHanks
5JackNicholson

Roles

role_idfilm_iddirector_idproducer_idactor_id
(→ Films.id)(→ Director.director_id)(→ Producer.producer_id)(→ Actor.actor_id)
11234
22145
33657
44878
55989