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
- Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify t…
- Which of the following is true about the HAVING clause ?
- Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation ?
- Which of the following is not a DDL command ?
- The command center of MS-Access file that appears when you create or open the MS-Access database file, is called :
- A functional dependency is a relationship between or among :