A movie platform database contains information about actors $($identified by actorid$)$ and

information about movies $($identified by movieid$).$ Actors also have a name, a date of birth

$($dob$),$ a phone and an address. Each movie also has a name, a genre, a release year and a

studio. Actors play in movies.

a$)$ Draw the ER diagram of this database $($as described in the Question $1$ statement$).$ Do

not use any other constraints.

b$)$ Modify the diagram from a further to add the constrain that in each movie at least one

actor must play.

c$)$ Modify the diagram from b further to add the constraint that each actor must play in at

most one movie

d$)$ Modify the diagram from c further such that each actor must play in exactly one movie.

e$)$Modify the diagram from d further such that each actor can have multiple addresses

identified by street, city and state.

f$)$ Modify the diagram from e further such that each actor must have at least one address.

NOTES:

$$ ER diagrams should strictly follow the notations used in class. No other notations will

receive any points.

$$ Each problem from a through i must have its own ER diagram, for the total of six.

$$ Each problem has carries $6$ points.

Please use the most common notations used. Thank you