ISRO Computer Science (CSE) 2014 - Question 30

All ISRO Computer Science (CSE) papers | ISRO Computer Science (CSE) 2014

Every time the attribute $A$ appears, it is matched with the same value of attribute $B$ but not the same value of attribute $C$. Which of the following is true?

  • A. $A \to (B, C)$
  • B. $A \to B, A \to\to C$
  • C. $A \to B, C \to\to A$
  • D. $A \to\to B, B \to C$

Answer: B. $A \to B, A \to\to C$

Explanation: $A \to B$ means A determines B (functional dependency). The statement says A matches same B.\n"Not same value of C" implies A does not determine C functionally, but might be a multi-valued dependency $A \to\to C$ if C's values depend only on A?

| | All questions of ISRO Computer Science (CSE) 2014