What type of functional dependency must be eliminated to ensure a relation is…
2025
What type of functional dependency must be eliminated to ensure a relation is in Second Normal Form (2NF)?
Answer: C. Partial dependency on a subset of a composite primary key
- A.
Circular dependency among attributes
- B.
Transitive dependency between non-key attributes
- C.
Partial dependency on a subset of a composite primary key
- D.
Multivalued dependency on a super key
Attempted by 839 students.
Show answer & explanation
Correct answer: C
Loading lesson…