## Visual_Medium

ID | Title | Visual_Media | Genre | Release_Year | Duration
--- | --- | --- | --- | --- | ---
1 | The Shawshank Redemption | Movie | Drama | 1994 | 2.03
2 | Ace Ventura: Pet Detective | Movie | Comedy | 1994 | 1.67
3 | Friends | TV Show | Comedy | 1994 | None
4 | Breaking Bad | TV Show | Crime Drama | 2008 | None

## Actors

Actor_ID | FirstName | LastName | DateOfBirth | Bio
--- | --- | --- | --- | ---
1 | Tom | Hanks | 1956-07-09 | American actor and filmmaker
2 | Jim | Carrey | 1962-01-17 | Canadian-American actor, comedian, and screenwriter

## Roles

Role_ID | Movie_or_Show_Title | Character_Name
--- | --- | ---
| (→ Visual_Medium.Title) |
1 | The Shawshank Redemption | Andy Dufresne
2 | Ace Ventura: Pet Detective | Ace Ventura

## Casting

Casting_ID | Actor_ID | Role_ID | Year_Played
--- | --- | --- | ---
| (→ Actors.Actor_ID) | (→ Roles.Role_ID) |
1 | 1 | 1 | 1994
2 | 2 | 2 | 1994

## Directors

Director_ID | FirstName | LastName | BirthDate | Biography
--- | --- | --- | --- | ---
1 | Frank | Darabont | 1959-01-28 | Iranian American film director, producer, screenwriter and author.
2 | Tom | Shadyac | 1958-05-30 | American film director, writer, producer, and humorist.

## Productions

Production_ID | Movie_or_Show_Title | Director_ID | Budget | BoxOffice
--- | --- | --- | --- | ---
|  | (→ Directors.Director_ID) |  |
1 | The Shawshank Redemption | 1 | 25000000.0 | 106850000.0
2 | Ace Ventura: Pet Detective | 2 | 15000000.0 | 165000000.0

## Directs

Directs_ID | Director_ID | Movie_or_Show_Title | Year_Directed
--- | --- | --- | ---
| (→ Directors.Director_ID) | (→ Visual_Medium.Title) |
1 | 1 | The Shawshank Redemption | 1994
2 | 2 | Ace Ventura: Pet Detective | 1994