A function that has no partial functional dependencies is in …….. form.
एक फंक्शन जिसमें कोई आंशिक कार्यात्मक निर्भरता नहीं है …….. के रूप में है।
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: B. 2NF
Explanation
A relation (the question says 'function') in 1NF with no partial dependency on part of a composite key is in 2NF.
1NF में जो रिलेशन किसी आंशिक निर्भरता (partial dependency) से मुक्त हो, वह 2NF में होता है।
More Database Management & SQL questions
- Which of the following is not a valid aggregate function ?
- SQL Views are also known as :
- If one attribute is determinant of second, which in turn is determinant of third, then the relation cannot be :
- 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 ?