A Video Movie Rental Store Is Using A Relational Database To

A video movie rental store is using a relational database to store information on movie rentals to answer customer questions. Each entry in the database contains the following items: Movie ID No. (primary key), Movie Title, Year Made, Movie Type, MPAA Rating, Number of Copies on Hand, and Quantity Owned. Movie types are comedy, family, drama, horror, science fiction, and western. MPAA ratings are G, PG, PG-13, R, NC-17, and NR (not rated). Use a single-user database management system to build a data-entry screen to enter this data. Build a small database with at least ten entries.

Posted in Uncategorized