If one attribute is determinant of the second, which in turn is determinant of the third, then the relation cannot be

If one attribute is determinant of the second, which in turn is determinant of the third, then the relation cannot be in which of the following?

A. Third Normal Form

B.First Normal Form

C. Second Normal Form

D. None of these

Answer : A. Third Normal Form

Explanation

X->Y->Z

This kind of dependency is commonly known as a transitive dependency.

According to the third normal form, there should be no transitive dependency. So the correct answer is D.

third normal form transitive dependency in database

Highly Recommended  Important MCQs with Explanation

Computer Science MCQs (Homepage)

Prof.Fazal Rehman Shamil (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.