All mock tests are FREE till 31 December — register to save your progress
Unit 5 · Database Management & SQL HTET 2021 PGT Computer Science

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

यदि एक एट्रिब्यूट दूसरे का निर्धारक है, जो बदले में तीसरे का निर्धारक है, तो यह संबंध क्या नहीं हो सकता ?

Pick an option to check yourself, or open the answer below.

Show answer & explanation

Correct answer: D. 3NF

Explanation

A → B and B → C is a transitive dependency, which 3NF forbids; such a relation cannot be in 3NF.

A → B और B → C संक्रामी (transitive) निर्भरता है जो 3NF में नहीं होनी चाहिए; अतः रिलेशन 3NF में नहीं हो सकता।

More Database Management & SQL questions