Match the following: List-I (1) Determinants (2) Candidate key (3)…
2009
Match the following:
List-I
(1) Determinants
(2) Candidate key
(3) Non-redundancy
(4) Functional dependency
List-II
(a) No attribute can be added
(b) Uniquely identified a row
(c) A constraint between two attributes
(d) Group of attributes on the left-hand side of arrow of function dependency.
- A.
1 – d, 2 – b, 3 – a, 4 – c
- B.
2 – d, 3 – a, 1 – b, 4 – c
- C.
4 – a, 3 – b, 2 – c, 1 – d
- D.
3 – a, 4 – b, 1 – c, 2 – d
Attempted by 23 students.
Show answer & explanation
Correct answer: A
The correct matching is as follows: 1. Determinants correspond to the group of attributes on the left-hand side of the arrow in a functional dependency, so (1) matches with (d). 2. A Candidate key uniquely identifies a row in a relation, so (2) matches with (b). 3. Non-redundancy implies that no attribute can be added without violating uniqueness or minimality, so (3) matches with (a). 4. A Functional dependency represents a constraint between two attributes, so (4) matches with (c). Therefore, the correct sequence is 1-d, 2-b, 3-a, 4-c.
A video solution is available for this question — log in and enroll to watch it.