ActorID | FirstName | LastName | BirthDate | Film_Profession | Award |
---|---|---|---|---|---|
1 | John | Doe | 1960-07-23 | Director | Oscar |
2 | Jane | Smith | 1985-08-10 | Director | Golden Globe |
3 | Alice | Brown | 1975-09-11 | Producer | Oscar |
4 | Bob | White | 1990-10-12 | Producer | Emmy |
MovieID | Title | ReleaseYear | Genre |
---|---|---|---|
1 | The Shawshank Redemption | 1994 | Drama |
2 | Forrest Gump | 1994 | Drama |
3 | Pulp Fiction | 1994 | Crime |
4 | Good Will Hunting | 1997 | Drama |
RoleID | ActorID | MovieID | CharacterName | RoleType |
---|---|---|---|---|
(→ Actors.ActorID) | (→ Movies.MovieID) | |||
1 | 1 | 1 | Andy Dufresne | Lead |
2 | 1 | 2 | Tom Hanks | Supporting |
3 | 2 | 1 | Ellis Boyd "Red" Redding | Lead |
4 | 2 | 3 | Christopher Walken | Supporting |
AwardID | AwardeeID | AwardName | YearOfWinning |
---|---|---|---|
(→ Actors.ActorID) | |||
1 | 1 | Best Director Oscar | 1995 |
2 | 1 | Palme d'Or | 1995 |
3 | 2 | Best Picture Golden Globe | 1995 |
4 | 2 | BAFTA Best Film | 1995 |