This means a table should not contain repeating columns

Every column of a table should contain only atomic values

An atomic value is a value that … be divided further

is based on the concept of full functional dependency.

A relation with a single-attribute primary key is automatically in at least …

Second Normal Form (2NF) is based on the concept of … functional dependency

If the proper subset of candidate key determines non-prime attribute, it is called … dependency

A relation that is in First Normal Form and every non-primary-key attribute is fully functionally dependent on the primary key, then the relation is in

Non-prime attribute COURSE_FEE is dependent on a proper subset of the candidate key, which is a partial dependency and so this relation is in 2NF

2NF tries to reduce the redundant data getting stored in memory.