Problem #3: Representing roles in the Movie Database.

The Movie Database ER represents that an actor appeared in a movie. However, it doesn't represent the name of the role that the actor played in the movie. For example, we know that Harrison Ford played the role of Hans Solo in Star Wars. Revise the Movie Database ER to include this information. Warning! This question is harder than it may first appear. Hint: think about the cast of The Parent Trap, or The Wizard of Oz.)

Entity Relationship (ER) Model Entities Attributes Relationships (more on these later) ACTOR SAG SAGRACTOR ACTOR MOVIE BYear Name