Question: Topic: Databases | No Language / I don't know Create an ER from the following requirement. Use Chen notation with cardinality and participation notation and

Topic: Databases | No Language / I don't know Create an ER from the following requirement. Use Chen notation with cardinality and participation notation and make a separate diagram with UML notation. If you make an assumption that is not in the requirements, please note this on the ER. We are going to do a database for the film critic of a newspaper. The critic reviews movies and would like to keep track of the movies title, category (Humor, Drama, Action), and the date the movie was released. A title may have more than one category. We would also like to keep track of all the people who worked on or in the film. We would like to keep track of their name, ssn, job function (actor, crew). We are also required to be able to provide the total number of people who worked in or on the film but we will not store this number. All of our films have at least 3 workers and of course workers have worked on multiple films. Each film receives a (only one) rating review. The rating review data consists of a rating grade (PG, R, G), the date it was rated, comments about the film (there may be multiple comments), and the person who did the rating. We also would like to keep some information on the person who did the rating, his name, number of years in the field, and a description of his experience. A film is only rated by one rator but a rator may rate many films. Additional notes: We will need to search the database by worker last names

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!