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.

A relation that is in First and Second Normal Form and in which no non-primary-key attribute is transitively dependent on the primary key, then it is in

If A->B and B->C are two FDs then A->C is called transitive dependency

The normalization of 2NF relations to 3NF involves the ....of transitive dependencies

is considered adequate for normal relational database design because most of the … tablesare free of insertion, update, and deletion anomalies

(2NF) :always ensures functional dependency preserving and lossless.

If it fails to satisfy the n normal form condition, the highest normal form will be …

… is a software used to manage data from a database.