Country

IDName
1United States
2Canada
3France
4Germany
5Japan

ActingSchool

IDSchoolNameAddressPhoneNumberEmailAddressCountryID
(→ Country.ID)
1New York Film Academy123 Main St555-1234nyfa@example.com1
2London Film Academy456 High St555-5678lfa@example.co.uk2
3Paris Film Academy789 Avenue des Champs Elysées555-9012pfa@example.fr3
4Berlin Film Academy101 Unter den Linden555-8765bfa@example.de4
5Tokyo Film Academy202 Shibuya555-7654tfa@example.jp5

Festival

IDFestivalNameLocationDateCountryID
(→ Country.ID)
1Cannes Film FestivalCannes, France2023-05-123
2Toronto International Film FestivalToronto, Canada2023-09-082
3Venice Film FestivalVenice, Italy2023-09-013
4Telluride Film FestivalTelluride, United States2023-08-311
5Busan International Film FestivalBusan, South Korea2023-10-015

Movie

IDTitleReleaseYearDirectorGenreCountryID
(→ Country.ID)
1The Shawshank Redemption1994Frank DarabontDrama1
2Pulp Fiction1994Quentin TarantinoCrime1
3Forrest Gump1994Robert ZemeckisDrama1
4Inception2010Christopher NolanAction3
5Amélie2001Jean-Pierre JeunetRomantic Comedy3

CastMember

IDActorNameBirthDateNationalityActingSchoolID
(→ ActingSchool.ID)
1Tom Hanks1956-07-09American1
2Brad Pitt1963-12-18American1
3Kevin Spacey1959-07-26American1
4Emmanuel Mouret1967-10-12French4
5Natalie Portman1981-06-09Israeli American2

MovieCast

MovieIDCastIDRole
(→ Movie.ID)(→ CastMember.ID)
11Andy Dufresne
12Ellis Boyd Redding
13Warden Norton
21Jules Winnfield
22Butch Coolidge