In the movie ER model above, we focus on the binary relationship PRODUCES. Suppose we add an

Question:

In the movie ER model above, we focus on the binary relationship “PRODUCES”. Suppose we add an attribute type that indicates the time that each producer spent on producing each movie called “WORKING HOURS”. Which of the following scenarios is possible?

ALSO_A__ DIRECTOR dir-act act-dir DIRECTS (0..1) DIRECTOR (1..1) mov-dir dir-mov (0..1) PERFORMS IN ACTOR

a. We can migrate the attribute type “WORKING HOURS” to the “MOVIE” entity type.

b. We can migrate the attribute type “WORKING HOURS” to the “PRODUCER” entity type.

c. We can migrate the attribute type “WORKING HOURS” to either one of the linked entity types.

d. We can add the attribute type “WORKING HOURS” to the relationship type PRODUCES.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: