For a database relation R(a,b,c,d), where the domains a, b, c, d include only…

GATE · 1997 · CS · Question 6 subparts

For a database relation R(a,b,c,d), where the domains a, b, c, d include only atomic values, only the following functional dependencies and those that can be inferred from them hold: 

{ a → c, b → d }

This relation is

  1. A.

    in first normal form but not in second normal form

  2. B.

    in second normal form but not in first normal form

  3. C.

    in third normal form

  4. D.

    None of the above

Attempted by 855 students.

Show answer

Correct answer: A

The worked solution is available to enrolled students.

Explore the full course: Iocl Engineers Officers Grade A Paper 2

Loading lesson…