Sail E0 Webinar
Question
A table is in 3NF if it is in 2NF and if it has no ____________
Options:
A .  Functional Dependencies
B .  Transitive Dependencies
C .  Trivial Functional Dependency
D .  Multivalued Dependencies
Answer: Option B


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.



Was this answer helpful ?
Next Question

Submit Solution

Your email address will not be published. Required fields are marked *

Latest Videos

Latest Test Papers