Actors
ActorID | FirstName | LastName |
1 | John | Doe |
2 | Jane | Smith |
Directors
DirectorID | Name |
1 | Alice Johnson |
2 | Bob Brown |
Production_Company
CompanyID | CompanyName |
1 | Golden Films |
2 | Silver Screen Studios |
Movies
MovieID | Title | ReleaseYear | Genre | Stars | DirectorID |
| | | | | (→ Directors.DirectorID) |
1 | Action Movie 1 | 2021 | Action | Tom Cruise | 1 |
2 | Action Movie 2 | 2022 | Action | Someone Else | 2 |
3 | Adventure Movie 1 | 2023 | Adventure | Tom Cruise | 3 |
4 | Adventure Movie 2 | 2024 | Adventure | Someone Else | 4 |
Scene
SceneID | Description | MovieID |
| | (→ Movies.MovieID) |
1 | Scene 1 description | 1 |
2 | Scene 2 description | 1 |
ActorInMovie
MovieID | ActorID | Role |
(→ Movies.MovieID) | (→ Actors.ActorID) | |
1 | 1 | Lead role |
2 | 1 | Supporting role |
1 | 2 | Co-lead |
2 | 2 | Supporting role |