Actors

ActorIDFirstNameLastName
1JohnDoe
2JaneSmith

Directors

DirectorIDName
1Alice Johnson
2Bob Brown

Production_Company

CompanyIDCompanyName
1Golden Films
2Silver Screen Studios

Movies

MovieIDTitleReleaseYearGenreStarsDirectorID
(→ Directors.DirectorID)
1Action Movie 12021ActionTom Cruise1
2Action Movie 22022ActionSomeone Else2
3Adventure Movie 12023AdventureTom Cruise3
4Adventure Movie 22024AdventureSomeone Else4

Scene

SceneIDDescriptionMovieID
(→ Movies.MovieID)
1Scene 1 description1
2Scene 2 description1

ActorInMovie

MovieIDActorIDRole
(→ Movies.MovieID)(→ Actors.ActorID)
11Lead role
21Supporting role
12Co-lead
22Supporting role