Question: ( ACTORID , ACTOR _ FNAME, ACTOR _ LNAME, ROLEID, ROLE _ FNAME, ROLE _ LNAME, MOVIEID, MOVIETITLE, MOVIEYEAR, STUDIOID, STUDIONAME, PHONE ) Based on
ACTORID ACTORFNAME, ACTORLNAME, ROLEID, ROLEFNAME, ROLELNAME, MOVIEID, MOVIETITLE, MOVIEYEAR, STUDIOID, STUDIONAME, PHONE
Based on the relation above, which of the following is correct about this dependency:
MOVIEID ROLEID ACTORLNAME
This is a partial dependency
This is a transitive dependency
The determinant is a surrogate key
This is a full functional dependency
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
