Complete the sentence to define Second Normal Form (2NF).
A table is in Second Normal Form if it is in First Normal Form and every non-key attribute is fully [1] on the primary key.
Second Normal Form requires that all non-key attributes depend fully on the entire primary key, not just part of it.
Complete the sentence to explain when 2NF is applicable.
Second Normal Form applies only to tables with [1] primary keys.
2NF is concerned with removing partial dependencies, which only occur when the primary key has multiple columns (composite key).
Fix the error in the statement about 2NF.
A table in 2NF can have [1] dependency of non-key attributes on part of the primary key.
2NF eliminates partial dependency, so no non-key attribute should depend on only part of the primary key.
Fill both blanks to complete the example of a partial dependency.
In a table with primary key (StudentID, CourseID), the attribute [1] depends only on [2].
StudentName depends only on StudentID, not on the full composite key (StudentID, CourseID), which is a partial dependency.
Fill all three blanks to write a correct statement about 2NF.
To convert a table to 2NF, remove [1] dependencies by creating [2] tables and linking them with [3] keys.
Removing partial dependencies involves creating new tables and linking them with foreign keys to achieve 2NF.