NIELIT 2016 DEC Scientist B (IT) - Section B: 14

Question

Normalization from which is based on transitive dependency is classified as:

• A. First normal form.
• B. Second normal form.
• C. Fourth normal form.
• D. Third normal form.

Answer 1

Option D. Third Normal Form.

Since Third Normal Form ensures, no transitive dependency exists in Relational Schema.

Answer 2

ANS : D

FIRST NORMAL FORM : BASED ON SINGLE VALUE ATTRIBUTES .

SECOND NORMAL FORM : BASED ON PARTIAL DEPENDENCIES.

THIRD NORMAL FORM : BASED ON TRANSITIVE DEPENDENCY

HENCE THE CORRECT OPTION IS D