A table is in 3NF if it is in 2NF and if it has no ___________.
A. Functional Dependencies
B. Transitive Dependencies
C. Trivial Functional Dependency
D. Multivalued Dependencies
Answer:A
A table is in 3NF if it is in 2NF and if it has no ___________.
A. Functional Dependencies B. Transitive Dependencies C. Trivial Functional Dependency D. Multivalued Dependencies
Explanation: For a relation to be in Third Normal Form, it must be in Second Normal form and the following must satisfy:No non-prime attribute is transitively dependent on prime key attribute For any non-trivial functional dependency, X -> A, then eitherX is a superkey or,A is prime attribute.