If every non-key attribute is fully dependent on the primary key, then the…

2023

If every non-key attribute is fully dependent on the primary key, then the relation will be in ______.

  1. A.

    First Normal Form (1NF)

  2. B.

    Second Normal Form (2NF)

  3. C.

    Third Normal Form (3NF)

  4. D.

    More than one of the above

  5. E.

    None of the above

Attempted by 713 students.

Show answer & explanation

Correct answer: B

Step 1: First Normal Form (1NF) requires that all attributes contain atomic values and there are no repeating groups. It does not require full functional dependency of non-key attributes on the primary key. Step 2: Second Normal Form (2NF) requires the relation to be in 1NF and that every non-key attribute is fully functionally dependent on the primary key. This matches the given condition. Step 3: Third Normal Form (3NF) requires the relation to be in 2NF and that no non-key attribute is transitively dependent on the primary key. The given condition does not address transitive dependency. Step 4: Therefore, the relation will be in Second Normal Form (2NF).

Explore the full course: Up Lt Grade Assistant Teacher 2025