Together with you neighbor, draw an ER diagram that models a database about movies,
their stars and the studios that produce them,

Requirements: Movies have title, year they were made, length, and type. Stars act in
movies, and we would like to keep track of their names and addresses. Studios own
movies, and contract stars to appear in their movies. We would like to keep track of
studios' names and addresses.

Refinement 1: We would like to keep track of which movies are sequels, e.g., T2 is a
sequel of Terminator. How would you change your design to accommodate this
requirement?

Refinement 2: We need to record the salary a star was paid to star in a movie, e.g.,
Arnold was paid 10M to star in Terminator, and 100M to star in T2. Where should you
add the "salary" attribute?

Questions:
1. Should we have studios as a separate entity or as an attribute of movies? What if
we did not care about studio addresses?
2. What happens in your design if a studio sells a movie to another studio?
3. What is the appropriate key for movies?
4. Is your design redundancy-free?

credit to: Maintained by Juliana Freire.