Q1. A movie database contains information about movies and actors/actresses. Each movie is identified by title and year

[answerhappygod]

Q1 A Movie Database Contains Information About Movies And Actors Actresses Each Movie Is Identified By Title And Year 1 (100.86 KiB) Viewed 32 times

Q1. A movie database contains information about movies and actors/actresses. Each movie is identified by title and year of release. A movie has a genre (drama, comedy, etc.), a running time, and one director. A movie is made at a movie studio and may have multiple producers (people in charge of the movie production). A movie studio has a unique name and address and may make one or more movies. Producers are identified by name and date of birth and produce one or more movies. Directors are also identified by name and date of birth and direct one or more movies. Assume that directors do not act or produce movies. Actors are identified by name and date of birth and may appear in one or more movies. An actor who appears in a movie, has a role. There may be one or more actors that appear in the movie and some of them may be in the lead role. Assume that there are no actors who are directors and/or producers. Design the Entity-Relationship diagram b) Show all the functional dependencies that should hold among the attributes. c) Draw the relational schemas for the database that are each in Third Normal Form (3NF)