Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started