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 (primary key)
Movie Title (Title)
Year Made (Year)
Movie Type (Type)- Movie types are comedy, family, drama, horror, science fiction, western, etc.
Note: add any other types that you can think of
MPAA Rating (Rating)- MPAA ratings are G, PG, PG-13, R, X, and NR (not rated)
Number of Copies on Hand (COH)
Quantity Owned (Owned)
Use database software (Microsoft Access) to build the video movie rental table. Make sure each attribute (data item or field) is defined in the structure with an appropriate description.
Create a form and enter at least 10 tuples (records). Make sure to have a movie for each of the above mentioned Movie Types (comedy, family, drama, horror, science fiction, and western). Create a report showing all the data in tabular form and corporate format.
Make modifications (create another form and report by modifying existing form and report)
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.
From this list, choose two database modifications and modify the data entry screen to capture and store this new information and add the two new changes to your report.
Proposed changes:
A. Add the date that the movie was first available to help locate the newest releases
B. Add the director’s name
C. Add the names of three primary actors in the movie
D. Add a rating of one (*), two (**), three (***), four (****), or five (*****) stars
E. Add the number of Academy Award nominations
Required:
Make sure each attribute (data item or field) is defined in the structure with an appropriate description
Use the form to enter the new data in the database for all the records
Create another report and form showing all the data in tabular form and corporate format
Make sure to put the class information in the header of your report and the summary in the footer of the report. Your database should show two forms and two reports
Pass off:
Upload and submit your database file to Canvas.
Make sure to put your student header information in the header of your reports and make sure to put your summary in the footer of the reports.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]