In 2NF
2023
In 2NF
- A.
No functional dependencies (FDs) exist
- B.
No multivalued dependencies (MVDs) exist
- C.
No partial FDs exist
- D.
No partial MVDs exist
Attempted by 562 students.
Show answer & explanation
Correct answer: C
Answer: c
Explanation: A relation is in 2NF if it is in 1NF and has no partial functional dependencies. This means no non-prime attribute should depend on a part of a candidate key. The condition of no partial FDs is the defining requirement for 2NF.