## Country

ID | Name
--- | ---
1 | United States
2 | Canada
3 | France
4 | Germany
5 | Japan

## ActingSchool

ID | SchoolName | Address | PhoneNumber | EmailAddress | CountryID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Country.ID)
1 | New York Film Academy | 123 Main St | 555-1234 | nyfa@example.com | 1
2 | London Film Academy | 456 High St | 555-5678 | lfa@example.co.uk | 2
3 | Paris Film Academy | 789 Avenue des Champs Elysées | 555-9012 | pfa@example.fr | 3
4 | Berlin Film Academy | 101 Unter den Linden | 555-8765 | bfa@example.de | 4
5 | Tokyo Film Academy | 202 Shibuya | 555-7654 | tfa@example.jp | 5

## Festival

ID | FestivalName | Location | Date | CountryID
--- | --- | --- | --- | ---
|  |  |  | (→ Country.ID)
1 | Cannes Film Festival | Cannes, France | 2023-05-12 | 3
2 | Toronto International Film Festival | Toronto, Canada | 2023-09-08 | 2
3 | Venice Film Festival | Venice, Italy | 2023-09-01 | 3
4 | Telluride Film Festival | Telluride, United States | 2023-08-31 | 1
5 | Busan International Film Festival | Busan, South Korea | 2023-10-01 | 5

## Movie

ID | Title | ReleaseYear | Director | Genre | CountryID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Country.ID)
1 | The Shawshank Redemption | 1994 | Frank Darabont | Drama | 1
2 | Pulp Fiction | 1994 | Quentin Tarantino | Crime | 1
3 | Forrest Gump | 1994 | Robert Zemeckis | Drama | 1
4 | Inception | 2010 | Christopher Nolan | Action | 3
5 | Amélie | 2001 | Jean-Pierre Jeunet | Romantic Comedy | 3

## CastMember

ID | ActorName | BirthDate | Nationality | ActingSchoolID
--- | --- | --- | --- | ---
|  |  |  | (→ ActingSchool.ID)
1 | Tom Hanks | 1956-07-09 | American | 1
2 | Brad Pitt | 1963-12-18 | American | 1
3 | Kevin Spacey | 1959-07-26 | American | 1
4 | Emmanuel Mouret | 1967-10-12 | French | 4
5 | Natalie Portman | 1981-06-09 | Israeli American | 2

## MovieCast

MovieID | CastID | Role
--- | --- | ---
(→ Movie.ID) | (→ CastMember.ID) |
1 | 1 | Andy Dufresne
1 | 2 | Ellis Boyd Redding
1 | 3 | Warden Norton
2 | 1 | Jules Winnfield
2 | 2 | Butch Coolidge