Nicole wants to create a database to collect information about videos in her video rental store. She would like to use the database to look up movies by rating, actors, producer, and title. She would also like to retrieve the movies that are in stock. What fields should she have in her database? title, rating, actor, and producer rating, director, and actor title, rating, actor 1, actor 2, actor 2, actor 4, producer, and in stock product number, price, and rating

All the field which she has mention has to created by Nichole in her database.

Explanation:

The following fields have to be created in the database

title, rating, actor, and producer rating, director, and actor title, rating, actor 1, actor 2, actor 2, actor 4, producer, and in the stock product number, price, and rating

And additional field also has to create movie-length also as integer field which should carry the length of the movie

Date of release and movie certificate also can be captured so the search engine will be very useful