NTA UGC NET Dec 2023 Paper-2
January 19, 2024NTA UGC NET Dec 2023 Paper-2
January 19, 2024NTA UGC NET Dec 2023 Paper-2
|
Question 11
|
Match List – I with List II.
Choose the correct answer from the options given below:
Choose the correct answer from the options given below:
|
(A)-(III), (B)-(II), (C)-(I), (D)-(IV)
|
|
|
(A)-(IV), (B)-(I), (C)-(II), (D)-(III)
|
|
|
(A)-(II), (B)-(III), (C)-(IV), (D)-(I)
|
|
|
(A)-(IV), (B)-(I), (C)-(III), (D)-(II)
|
Question 11 Explanation:
(A) BCNF iff (II) all underlying domains contain scalar values only This is true because BCNF (Boyce-Codd Normal Form) requires that all attributes are functionally dependent on the primary key, and all domains should contain only atomic (scalar) values.
(B) 5 NF iff (III) every MVD is implied by the candidate keys This is true because 5NF (Fifth Normal Form) deals with multivalued dependencies (MVDs), and it requires that every MVD is implied by the candidate keys.
(C) 1 NF iff (IV) every FD is implied by the candidate keys This is true because 1NF (First Normal Form) deals with the elimination of repeating groups, and it ensures that every functional dependency (FD) is implied by the candidate keys.
(D) 4 NF iff (I) every ID is implied by the candidate keys This is true because 4NF (Fourth Normal Form) deals with multivalued dependencies, and it requires that every implied dependency (ID) is implied by the candidate keys.
(B) 5 NF iff (III) every MVD is implied by the candidate keys This is true because 5NF (Fifth Normal Form) deals with multivalued dependencies (MVDs), and it requires that every MVD is implied by the candidate keys.
(C) 1 NF iff (IV) every FD is implied by the candidate keys This is true because 1NF (First Normal Form) deals with the elimination of repeating groups, and it ensures that every functional dependency (FD) is implied by the candidate keys.
(D) 4 NF iff (I) every ID is implied by the candidate keys This is true because 4NF (Fourth Normal Form) deals with multivalued dependencies, and it requires that every implied dependency (ID) is implied by the candidate keys.
Correct Answer: C
Question 11 Explanation:
(A) BCNF iff (II) all underlying domains contain scalar values only This is true because BCNF (Boyce-Codd Normal Form) requires that all attributes are functionally dependent on the primary key, and all domains should contain only atomic (scalar) values.
(B) 5 NF iff (III) every MVD is implied by the candidate keys This is true because 5NF (Fifth Normal Form) deals with multivalued dependencies (MVDs), and it requires that every MVD is implied by the candidate keys.
(C) 1 NF iff (IV) every FD is implied by the candidate keys This is true because 1NF (First Normal Form) deals with the elimination of repeating groups, and it ensures that every functional dependency (FD) is implied by the candidate keys.
(D) 4 NF iff (I) every ID is implied by the candidate keys This is true because 4NF (Fourth Normal Form) deals with multivalued dependencies, and it requires that every implied dependency (ID) is implied by the candidate keys.
(B) 5 NF iff (III) every MVD is implied by the candidate keys This is true because 5NF (Fifth Normal Form) deals with multivalued dependencies (MVDs), and it requires that every MVD is implied by the candidate keys.
(C) 1 NF iff (IV) every FD is implied by the candidate keys This is true because 1NF (First Normal Form) deals with the elimination of repeating groups, and it ensures that every functional dependency (FD) is implied by the candidate keys.
(D) 4 NF iff (I) every ID is implied by the candidate keys This is true because 4NF (Fourth Normal Form) deals with multivalued dependencies, and it requires that every implied dependency (ID) is implied by the candidate keys.