How to apply the second normal form

Description

• For a table to be in second normal form, every non-key column must depend on the entire primary key. If a column doesn’t depend on the entire key, it indicates that the table contains information for more than one entity. This is reflected by the table’s composite key.
• To apply second normal form, you move columns that don’t depend on the entire primary key to another table and then establish a relationship between the two tables.
• Second normal form helps remove redundant row data, which can save storage space, make maintenance easier, and reduce the chance of storing inconsistent data.