To improve service to their customers, the sales people at the 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
a. To help store clerks locate the newest releases, add the date that the movie was first available.
b. Add the director name.
c. Add the names of three primary actors in the movie.
d. Add a rating of one, two, three, or four stars.
e. Add the number of Academy Award nominations.