Problem $1$

Consider a database that keeps track of scenes filmed for different movies. The database should keep track of all the information mentioned in this scenario.

A movie uses a screenplay $($or story$)$ that is organized into scenes. The movie will also have the same scenes because the movie follows the screenplay.

Not all screenplays in the database become movies but we want the database to keep track of all the screenplays regardless. The database should keep track of the screenplay's title and author.

Every movie is of a particular screenplay. Also, a screenplay is used for only one movie. That is$,$ there are not two different movies made of the exact same screenplay.

Scenes have a story$-$location where the story takes place and a filming$-$location where the filming will actually be done. Each scene has some actors that appear in that scene. Actors have a name, phone number, address and named agent that represents them. The database should keep track of which actors are needed for which scenes so it can be used to make up the shooting schedule.

A scene can be filmed more than once $($maybe the actor forgot their lines$).$ Each filming of a scene is called a $$take$.$ The movie is typically created by using the best take of each scene and putting them together in the correct order. The database will be used to print a "cutlist" which is a list of takes that make up a particular movie and the order in which the takes should appear. $($In reality a movie is cut with partial takes but for this exercise we will assume complete takes are used to assemble the movie.$)$