Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Identify and describe a suggested outline of a business plan.

Answered: 1 week ago

Question

9. Power and politics can be destructive forces in organizations.

Answered: 1 week ago