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 |
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 |
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_ID | Actor_ID | Role_ID | Year_Played |
---|---|---|---|
(→ Actors.Actor_ID) | (→ Roles.Role_ID) | ||
1 | 1 | 1 | 1994 |
2 | 2 | 2 | 1994 |
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. |
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_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 |