Assuming the relation is in 1NF and its primary key is its only candidate key,…

ISRO Scientist/Engineer SC · 2020 · Computer ScienceModified — slightly modified from the official paper; see the solution

Assuming the relation is in 1NF and its primary key is its only candidate key, if every non-key attribute is fully functionally dependent on the whole primary key, what is the highest normal form guaranteed by these conditions?

  1. A.

    First normal form

  2. B.

    Second normal form

  3. C.

    Third normal form

  4. D.

    Fourth normal form

Attempted by 27 students.

Show answer

Correct answer: B

The worked solution is available to enrolled students.

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

Loading lesson…