For your capstone project, create a database to keep track of your personal DVD movie collection (if you don’t own any movies on DVD, feel free to make some up). The database will store information about your movies, your friends, and which friends have borrowed which movies.
The database should have at least the following:
Tables
• A table for movies that stores the title, director, genre, and year of each movie
o Enter at least ten records into this table
• A table for friends that stores the first name, last name, and address of each friend
o Enter at least five records into this table
• A table to keep track of which friends have borrowed which movies, including the date of the borrow
o Enter at least twenty records into this table
• Create appropriate relationships between the tables
Queries
• A query that shows the titles of all movies that have been borrowed more than five times, as well as the number of times they’ve been borrowed.
• A query that shows only movies from a genre of your choice
• A query that shows each time a friend has borrowed a movie, as well as the date of the borrow
Forms
• A form to enter data into each of the three tables
o Delete the Primary Key field and label from each form
o Add three buttons to each form: one to go to the next record, one to go to the previous record, and one to add a new record.
Reports
• A report that shows how many times each movie has been borrowed, grouped by genre
• A report that shows all of the information from the movies table, except for the primary key
o Both reports should be well-formatted, aesthetically pleasing, and easy to understand
Scoring Rubric
3 2 1 0
Tables Database contains all required tables and fields, with records stored in each one Database contains all required tables but is missing fields or records Database is missing at least one required table Database does not contain any of the required tables
Relationships All necessary relationships have been created Most necessary relationships have been created Some necessary relationships have been created No relationships have been created
Queries All required queries are present, with no errors All required queries are present, with few errors Some of the required queries are not present or do not function None of the required queries are present, or none of the queries function
Forms All required forms are present. They look good and have all required buttons All required forms are present. They look OK and have some buttons Forms are present, but they are ugly and/or don’t have buttons Forms are not present
Reports All required reports are present and are aesthetically pleasing All required reports are present and they look OK Some reports are missing or don’t contain the information they should Reports are not present
Total: ___/15