Consider the following relational database to track movies. The schemas (with primary key attributes underlined for the first two relations) are: Actor-schema = (actorname, lifetime_salary) Movie-schema = (movie_name, release_date, revenue) StarsIn-schema = (actor_name, movie_name, release_date, salary_for_movie) a) (5 points) Suppose that an actor only ever appears in one movie. What would the primary key for the StarsIn-schema be? b) (5 points) Suppose that a movie only ever has one actor. What would the primary key for the StarsIn-schema be? c) (20 points) Suppose that a movie can have multiple actors, and an actor can star in multiple movies. Draw a schema diagram for this database. Be sure to indicate all foreign keys implied by the attribute names and primary keys in the relation schemas.

Database homework