This question was previously asked in

Punjab Patwari Previous Paper 2 (Held On: 20 Nov 2016 )

Option 3 : transitive dependencies

Correct Sentence

6281

10 Questions
10 Marks
9 Mins

The correct answer is **transitive dependencies.**

**Concept:**

A relation is in third normal form, **if there is no transitive dependency **for non-prime attributes as well as it is in second normal form.** Therefore Option 3 is correct**

__Additional Information__

A relation is in 3NF if at least one of the following condition holds in every non-trivial function dependency X –> Y:

- X is a super key.
- Y is a prime attribute (each element of Y is part of some candidate key).