Normalization Fundamentals Quiz

What is unnormalized data?

What is the process of normalization?

What are the objectives of normalization?

What is the first normal form (1NF)?

• There are no repeating groups and the primary key is identified.

• 1NF and all the columns depend on the table’s primary key.

• 2NF and there are no non-key attributes determined by another non-key attribute.

• Every determinant is a candidate key.

• 3NF and no independent multivalued dependencies.

What is the second normal form (2NF)?

• There are no repeating groups and the primary key is identified.

• 1NF and all the columns depend on the table’s primary key.

• 2NF and there are no non-key attributes determined by another non-key attribute.

• Every determinant is a candidate key.

• 3NF and no independent multivalued dependencies.

What is the third normal form (3NF)?

• There are no repeating groups and the primary key is identified.

• 1NF and all the columns depend on the table’s primary key.

• 2NF and there are no non-key attributes determined by another non-key attribute.

• Every determinant is a candidate key.

• 3NF and no independent multivalued dependencies.

What is Boyce-Codd normal form (BCNF)?

• There are no repeating groups and the primary key is identified.

• 1NF and all the columns depend on the table’s primary key.

• 2NF and there are no non-key attributes determined by another non-key attribute.

• Every determinant is a candidate key.

• 3NF and no independent multivalued dependencies.

What is the fourth normal form (4NF)?

• There are no repeating groups and the primary key is identified.

• 1NF and all the columns depend on the table’s primary key.

• 2NF and there are no non-key attributes determined by another non-key attribute.

• Every determinant is a candidate key.

• 3NF and no independent multivalued dependencies.

What is the highest level of normalization necessary for most applications?

• 1NF

• 2NF

• 3NF

• BCNF

• 4NF