Every time the attribute A appears, it is matched with the same value of…

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?

  1. A.

    A-> (B,C)

  2. B.

    A ->B, A->>C

  3. C.

    A->B, C->>A

  4. D.

    A->>B, B->C

Attempted by 546 students.

Show answer & explanation

Correct answer: B

In database theory, when attribute A determines attribute B uniquely (every value of A matches the same value of B), this represents a Functional Dependency, denoted as A → B. When attribute C does not have a unique value for each A (multiple values of C can exist for the same A), this indicates a Multivalued Dependency, denoted as A →> C. Thus, the relationships are defined by A → B and A →> C.

Explore the full course: Isro