Removing partial dependency of a non-key attribute on part of a composite primary key brings a table to which normal form?
- A.First normal form
- B.Second normal form
- C.Third normal form
- D.Boyce-Codd normal form
Show answer
A table is in second normal form when it is already in first normal form and no non-key attribute depends on only a part of a composite primary key; such a partial dependency is removed by moving that attribute into a table of its own.
Read the full explanation →