Consider a relation arr(a1, a2, a3). The functional dependencies are given…

Consider a relation arr(a1, a2, a3).

The functional dependencies are given below in the form of XY, which means Y is functionally dependent on X.

a1→a2

a1,a2→a3

Identify the non-prime attributes of the relation “arr”.

  1. A.

    a1 and a2

  2. B.

    a2 and a3

  3. C.

    a1 and a3

  4. D.

    a1, a2 and a3

Attempted by 608 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…