

InterviewSolution
Saved Bookmarks
1. |
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 DependenciesThe question was asked in an online quiz.This intriguing question originated from Normalization in section Planning Oracle Applications of Oracle |
Answer» <html><body><p>Correct option is (<a href="https://interviewquestions.tuteehub.com/tag/b-387190" style="font-weight:bold;" target="_blank" title="Click to know more about B">B</a>) Transitive Dependencies<br/><br/>Easy explanation: For a relation to be in Third Normal Form, it <a href="https://interviewquestions.tuteehub.com/tag/must-2185568" style="font-weight:bold;" target="_blank" title="Click to know more about MUST">MUST</a> be in Second Normal form and the following must <a href="https://interviewquestions.tuteehub.com/tag/satisfy-1195236" style="font-weight:bold;" target="_blank" title="Click to know more about SATISFY">SATISFY</a>:No non-prime attribute is <a href="https://interviewquestions.tuteehub.com/tag/transitively-7384444" style="font-weight:bold;" target="_blank" title="Click to know more about TRANSITIVELY">TRANSITIVELY</a> dependent on prime key attribute For any non-trivial functional <a href="https://interviewquestions.tuteehub.com/tag/dependency-948489" style="font-weight:bold;" target="_blank" title="Click to know more about DEPENDENCY">DEPENDENCY</a>, X -> A, then eitherX is a superkey or,A is prime attribute.</p></body></html> | |