Which normal form is based on the concept of 'full functional dependency'?

2011

Which normal form is based on the concept of 'full functional dependency'?

Answer: B. Second Normal FormThe Second Normal Form (2NF) is based on the concept of full functional dependency. It requires that all non-key attributes be fully dependent on the entire…

  1. A.

    First Normal Form

  2. B.

    Second Normal Form

  3. C.

    Third Normal Form

  4. D.

    Fourth Normal Form

Attempted by 1468 students.

Show answer & explanation

Correct answer: B

The Second Normal Form (2NF) is based on the concept of full functional dependency. It requires that all non-key attributes be fully dependent on the entire primary key, eliminating partial dependencies found in First Normal Form.

A video solution is available for this question — log in and enroll to watch it.

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

Loading lesson…