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 ______.
- A.
First Normal Form (1NF)
- B.
Second Normal Form (2NF)
- C.
Third Normal Form (3NF)
- D.
More than one of the above
- 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).