UGC NET CSE | December 2009 | Part 2 | Question: 18

Question

Match the following :

$\begin{array}{clcl}  \text{(1)} & \text{Determinants}  & \text{(a)}\ & \text{No attribute can be added} \\   \text{(2)} & \text{Candidate key}  & \text{(b)}\ & \text{Uniquely identified a row} \\  \text{(3)} & \text{Non-redundancy}  & \text{(c)}\ & \text{A constraint between two attribute} \\   \text{(4)} & \text{Functional Dependency}  & \text{(d)}\ & \text{Group of attributes on the left hand} \\ &&&  \text{side of arrow of function dependency.} \\  \end{array}$

• A. $\text{1-d, 2-b, 3-a, 4-c}$
• B. $\text{2-d, 3-a, 1-b, 4-c}$
• C. $\text{4-a, 3-b, 2-c, 1-d}$
• D. $\text{3-a, 4-b, 1-c, 2-d}$

Answer 1

if X->Y is a functional dependency X is called determinant.

Candidate key uniquely identify a row.

Non redundancy : No attribute can be added

Functional dependency : A constraint between two attribute

 

so answer option (a)..