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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started