Question: The primary key of the relation PROJECT _ TASK is a composite key consisting of the two attributes PROJECT _ NUMBER and TASK _ NUMBER.
The primary key of the relation PROJECTTASK is a composite key consisting of the two attributes PROJECTNUMBER and TASKNUMBER. It has only one nonkey attribute, STARTDATE, which is functionally dependent on the entire composite primary key. In what normal form is this relation and why?
NF because there is a partial functional dependency.
NF because there is a partial functional dependency.
NF because there is a transitive dependency.
NF because there is a transitive dependency.
none of the above.
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
