Question: ( ACTORID , ACTOR _ FNAME, ACTOR _ LNAME, ROLEID, ROLE _ FNAME, ROLE _ LNAME, MOVIEID, MOVIETITLE, MOVIEYEAR, STUDIOID, STUDIONAME, PHONE ) Based on

(ACTORID, ACTOR_FNAME, ACTOR_LNAME, ROLEID, ROLE_FNAME, ROLE_LNAME, MOVIEID, MOVIETITLE, MOVIEYEAR, STUDIOID, STUDIONAME, PHONE)
Based on the relation above, which of the following is correct about this dependency:
(MOVIEID, ROLEID) ACTOR_LNAME
This is a partial dependency
This is a transitive dependency
The determinant is a surrogate key
This is a full functional dependency
( ACTORID , ACTOR _ FNAME, ACTOR _ LNAME, ROLEID,

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 Programming Questions!