Consider a movie database in which data is recorded about the movie industry. The data requirements are summarized as follows:
• Movies are identified by their title and year of release. They have a length in minutes. They also have a studio that produces the movie and are classified under one or more genres (such as horror, action, drama etc). Movies are directed by one or more directors and have one or more actors acting in them. The movie also has a plot outline. Each movie also has zero or more quotable quotes that are spoken by a particular actor acting in the movie.
• Actors are identified by their names and date of birth and act in one or more movies. Each actor has a role in the movie.
• Directors are also identified by their names and date of birth and direct one or more movies. It is possible for a director to act in a movie (not necessarily in a movie they direct).
• Studios are identified by their names and have an address. They produce one or more movies.
Design an Entity-Relationship diagram for the movie order database and enter the design using a data-modeling tool such as ERWin.