Credit Task 3.2 Advanced ER Modelling Subtask 3.2.1 Consider the following user requirements which describe a MOVIE database system in a movie industry. Each movie is identied by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classied under one or more genres {such as horror, action, drama, and so forth). Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie. Actors are identied by name and date of birth and appear in one or more movies. Each actor has a role in the movie. Directors are also identied by name and date of birth and direct one or more movies. It is possible for a director to act in a movie (including one that he or she may also direct}. Production companies are identied by name and each has an address. A production company produces one or more movies. Draw a diagram for the movie system above. Note that a good design will include several weak entities. Add the solution to your lab report