Designing the Database
The questions below are to be answered in written form using MS Word. Please make sure that you include the following for this Task: --
Task 1, centred and bold as a title
-- Please include a copy of each question you are attempting, with your response below. Task 1 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:
A. 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).
B. I like to rate movies the same way.
C. I like to rate performances by each actor in a given movie in the same manner. .
D. 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.
E. I expect to always have the data on actors and movies completed before I rate their
performances in a given role.
You find that I have already made a start on the database, but you note that there are some
problems and data discrepancies. Here is what I have done so far:
Get Free Quote!
399 Experts Online