DATABASE: E-R DIAGRAMS

1) Write down any important assumptions you make about the data (e.g. what is unique, what pertains to an individual or group, etc.) that will help the marker understand your diagram.

2) An E-R diagram for the data model satisfying the following requirements.

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. Ask questions in class if you are unsure about what to keep track of. 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 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 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 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. The database should keep track of the "cutlist" which is the list of takes that make up a particular movie and the order in which the takes appear. (In reality a movie is cut with partial takes but for this exercise we will assume complete takes are used to make up the movie.)