Write a one page paper on how you would do it:
MS Access Project
Design a database application to keep track of movies, actors, and the roles played by actors in movies. You may make up all the data.
Designing the database requires that you analyze these items:
There is a many to many relationship between movies and actors. Use a roles table to resolve this many to many relationship.
A movie has roles for one or more actors. An actor plays roles in one or more movies.
Each movie has a movie id (an automatically generated number), movie name, genre (comedy, horror, action, etc.), year released, and rating. Movie id provides a primary key for movies.
Each actor has an actor id (automatically generated number), last name, first name, gender, date of birth, and place of birth. Actor id provides a primary key for actors.
Keep track of the name of each role played by an actor in a movie.
Initial data to enter:
You need to have at least five to fifteen movies.
You need to have at least five to twenty-five actors.
Forms to develop:
You need a main form with buttons that launch other forms and reports. This form will automatically display when your database loads up.
You need a form to enter movie information.
You need a form to enter actor information.
You need a form to enter roles for actors in movies. This could be combined with one of the other forms.
You need a form that lists all of the reports letting the user pick a report to run.
Queries to write:
Write queries to support the reports listed below.
Reports to write (pick any 4):
List of actors with their gender, birthdates, and place of birth, ordered by actor name.
List the actors with their date of birth and place of birth, ordered by date of birth in descending order. Also include their age (calculate this, do not store it in the database).
List of movies to include year of release, running length, MPAA rating, and genre.
List the actors with the number of unique movies each actor appeared in, ordered by actor name.
List the actors and their movies and roles, ordered by actor name then year of release. Group this by actors.
List genres and the movies in that genre. Group this by genre.
List actors and the movies they starred in, with the roles they played in the movie. Group this by actors.
List movies and their associated actors (with their roles). Group this by movies.