Question

______ normal form is based on the concept of transitive dependancy.
1. 1 NF
2. 2 NF
3. All options are wrong
4. 3 NF

Answer 1

Correct Answer - Option 4 : 3 NF

Concept

1NF

It does not contain any composite or multi-valued attribute.

2NF

A relation is in 2NF if it has No Partial Dependency i.e., no non-prime attribute (attributes which are not part of any candidate key) is dependent on any proper subset of any candidate key of the table

3NF

A relation is in 3NF if there is no transitive dependency for non-prime attributes as well as it is in second normal form.Transitive dependency occurs when FD (non-key-> non-key) exists in relation.

Therefore Option 3 is the correct answer