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 — Second Normal Form (2NF) requires eliminating partial dependencies on 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 766 students.
Show answer & explanation
Correct answer: C
Second Normal Form (2NF) requires eliminating partial dependencies on a composite primary key.
Loading lesson…