A company that provides a movie-streaming subscription service uses a relational database to store information on movies to answer customer questions. Each entry in the database contains the following items: Movie ID (the primary key), movie title, year made, movie type, MPAA rating, starring actor #1, starring actor #2, starring actor #3, and director. Movie types are action, comedy, family, drama, horror, science fiction, and western. MPAA ratings are G, PG, PG-13, R, NC-17, and NR (not rated). Using a graphics pro- gram, develop an entity-relationship diagram for a database application for this database.

To improve service to their customers, the employees of the movie-streaming company have proposed several changes that are being considered for the database in the previous exercise. From this list, choose two database modifications, and then modify the data-entry screen to capture

Also include TWO of the proposed changes (your choice):

1. Add the date that the movie was first released to the theaters.

2. Add the executive producers name.

3. Add a customer rating of one, two, three, four, or five stars, based on the number of rentals.

4. Add the number of Academy Award nominations.