Homework: Relational Databases, Access, and SQL
Learning Goals:
At the end of this homework you will be able to:
a. Analyse a basic problem from a structured, relational perspective;
b. Create an entity-relationship (ER) diagram to solve a basic database problem;
c. Create a simple relational database using MS Access;
d. Input data into an MS Access database;
e. Create, use, and display SQL queries from a relational database.
TASK A: Designing the Database
The questions below are to be answered in written form using MS Word. Make sure that you include the following for this Task:
Task A has you doing some role playing. I play the role of a film studies professor and you are a database designer. You are allowed to ask questions of me (the TA can stand in for me if I'm not available). Your job is to develop a Movies and Actors database for me.
The project seems straightforward. I need a database to hold records of all the actors and movies I am interested in. My research speciality is "actors" and the database must allow me to rate all of the actors I am interested in. I am also interested in the movies these actors appear in. I want to be able to rate and comment on each movie. Moreover, I also want to rate and make comments on the performances of each of these actors in each film.
After interviewing me, you discover I have some requirements regarding how I do my ranking. The requirements are as follows:
1) I always like to rate the actors out of 10, with 10 being excellent and 1 being horrid - the database will need to take this into account. I only use integers (e.g. no 6.5s).
2) I like to rate movies the same way.
3) I like to rate performances by each actor in a given movie in the same manner. .
4) I have no particular order to my data entry. Sometimes I will enter data about the actor before anything else. Sometimes I will enter data about the movie first.
5) I expect to always have the data on actors and movies completed before I rate their performances in a given role.
Format your homework according to the give formatting requirements:
a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
b. The response also includes a cover page containing the title of the homework, the course title, the student's name, and the date. The cover page is not included in the required page length.
c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.