| 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 |