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-> (B,C)
(B) A ->B, A->>C
(C) A->B, C->>A
(D) A->>B, B->C
Answer: (B)
Explanation: Functional dependency is a relationship that exists when one attribute uniquely determines another attribute, therefore A→B.
Multivalued dependency occurs when there are more than one independent multivalued attributes in a table. If A->> C is a dependency, it means for A, attribute C has more than one value.
So, option (B) is correct.
Quiz of this Question