QUESTION $1.[25$ points$]$

Consider the make believe world of the movie$-$industry. Movies are produced by studios or

independent producers. Each movie has a story or a topic$($documentary$).$ They have roles

played by actors. Story is written by an author and adapted by the same author or other

authors$($script writers$).$ A movie is directed by a director. Some times directors or authors also

have cameo roles in movies. Actors become directors and producers. Some directors write their

own stories and some authors produce their own movies. Actors are married $($to other actors$)$

and have children who may become actors, producers, directors.

Some movies or stories are remade with different actors and updated story lines. Other

movies end up with sequels.

Create a comprehensive E$-$R diagram of for a DB application which could be used to support

the world of movies. Make sure to indicate the keys of all entity sets,relationship sets and the

type of relationships. $($Give the answer in LucidChart please$)$