If a relation is in 2NF and 3NF forms then:
2012
If a relation is in 2NF and 3NF forms then:
- A.
no non-prime attribute is functionally dependent on other non-prime attributes
- B.
no non-prime attribute is functionally dependent on prime attributes
- C.
all attributes are functionally independent
- D.
prime attribute is functionally independent of all non-prime attributes
Attempted by 284 students.
Show answer & explanation
Correct answer: A
A relation in 2NF eliminates partial dependencies, while 3NF further eliminates transitive dependencies. Therefore, a relation in both forms ensures all non-prime attributes depend directly on the candidate key without transitive relationships.