Question

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

Answer 1

Nicole's video rental store database should have fields for title, rating, actors, producer, director, and in stock status to effectively manage her inventory and allow customers to search for movies by various attributes.

Step-by-step explanation:

Nicole should have the following fields in her database to collect information about videos in her video rental store: title, rating, actor 1, actor 2, actor 3, actor 4, producer, director, and in stock status. Each field serves a specific purpose; for example, the title is for the name of the movie, rating for age-appropriateness, actors and producer for identifying the cast and production team, director for the individual who oversees the creative aspects of the film, and the in stock status to retrieve the movies that are currently available for rent.

Answer 2

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

Step-by-step 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