| houseID | name |
|---|---|
| 1 | Warner Bros |
| 2 | Disney |
| 3 | Universal Pictures |
| 4 | Paramount Pictures |
| 5 | Fox |
| directorID | firstName | lastName |
|---|---|---|
| 1 | Christopher | Nolan |
| 2 | Quentin | Tarantino |
| 3 | Steven | Spielberg |
| 4 | Guillermo | del Toro |
| 5 | James | Cameron |
| movieID | title | genre | duration | productionHouseID |
|---|---|---|---|---|
| (→ Production_houses.houseID) | ||||
| 1 | Inception | Action Movie | 120 | 1 |
| 2 | Pulp Fiction | Action Movie | 180 | 2 |
| 3 | Notting Hill | Romantic Comedy | 120 | 3 |
| 4 | Avatar | Romantic Comedy | 190 | 4 |
| 5 | The Dark Knight | Action Movie | 160 | 1 |
| 6 | Indiana Jones and the Last Crusade | Action Movie | 130 | 2 |
| 7 | Pretty Woman | Romantic Comedy | 120 | 3 |
| 8 | Forrest Gump | Romantic Comedy | 170 | 4 |
| actorID | firstName | lastName |
|---|---|---|
| 1 | Leonardo | DiCaprio |
| 2 | Tom | Hanks |
| 3 | Meryl | Streep |
| 4 | Brad | Pitt |
| 5 | Kevin | Spacey |
| roleID | actorID | movieID | characterType |
|---|---|---|---|
| (→ Actors.actorID) | (→ Movies.movieID) | ||
| 1 | 1 | 1 | Protagonist |
| 2 | 2 | 2 | Antagonist |
| 3 | 3 | 3 | Leading Lady |
| 4 | 4 | 4 | Supporting Actor |
| 5 | 5 | 5 | Villain |
| directorID | movieID |
|---|---|
| (→ Directors.directorID) | (→ Movies.movieID) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |