a) Draw ER diagram or class diagram for the given scenario The client's ultimate objective is to have an online software system that gives information about the movies that the client sells to...

a) Draw ER diagram or class diagram for the given scenario

The client's ultimate objective is to have an online software system that gives information about the movies that the client sells to customers online. The system gives information about movies and actors/actresses. That is, the system should be accessed online. 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 don’t 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.