Third normal form is based on the concept of ______.

2012

Third normal form is based on the concept of ______.

  1. A.

    Closure Dependency

  2. B.

    Transitive Dependency

  3. C.

    Normal Dependency

  4. D.

    Functional Dependency

Attempted by 513 students.

Show answer & explanation

Correct answer: B

Third Normal Form (3NF) is based on the concept of transitive dependencies. It requires that all non-prime attributes are dependent only on the primary key and not on other non-key attributes, thereby eliminating transitive dependencies.

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

Explore the full course: Mppsc Assistant Professor