Question

Create an ER from the following requirement. Use Chen notation with cardinality and participation 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 movie’s 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

Answer 1

ER Diagram

Relational Schema