To improve service to their customers, the workers at the online video rental store have proposed a list of changes being considered for the database in the previous exercise. From this list, choose two database modifications and modify the data-entry screen to capture and store this new information. Proposed changes are as follows:
a. To help customers locate the newest releases, add the date that the movie was first available.
b. Add the director's name.
c. Add a customer rating of one, two, three, or four stars based on number of rentals.
d. Add the number of Academy Award nominations.