The questions below are to be answered in written form using MS Word. Please make sure that you include the following for this

computer science

Description

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:

Instruction Files

Related Questions in computer science category