ID | Name |
---|---|
1 | United States |
2 | Canada |
3 | France |
4 | Germany |
5 | Japan |
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 |
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 |
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 |
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 |
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 |