## Actors

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

## Movies

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

## Roles

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

## Awards

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