A relation is in Second Normal Form (2NF) if it is in 1NF and has no ________.
Options
-
A.
Transitive dependency
-
B.
Partial dependency
-
C.
Multivalued dependency
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
B.
Partial dependency
Detailed Explanation
- 2NF: A relation must first satisfy 1NF.
- It must have no partial dependency of a non-prime attribute on a candidate key.
- Partial dependency occurs when a non-key attribute depends on only part of a composite candidate key.
OOps! You are currently offline.