Question: SQL language For a Movies database with a Person entity and a Movie entity which have a relationship Acts_In, suppose we wanted to add a

SQL language

SQL language For a Movies database with a Person entity and a

For a Movies database with a Person entity and a Movie entity which have a relationship Acts_In, suppose we wanted to add a count of the number of movies for each person -that is, how many movies has an actor played a role in. How should we model this? Add the count as a regular attribute of the Person entity Add the count as a regular attribute of the Acts_In relationship Add the count as a derived attribute of the Acts_In relationship Add the count as a derived attribute of the Person entity

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!