Database Normalization Quiz

What is normalization in database design?

• A technique for data visualization

• A method for data encryption

• A process to increase data redundancy

• A process for evaluating and correcting table structures

Which normal form is considered the highest level of normalization for most business purposes?

• 4NF

• 1NF

• 3NF

• 2NF

What does 1NF stand for?

• First Normal Factor

• First Normal Function

• First Normal Format

• First Normal Form

What is a primary key?

• A key that can be duplicated

• A key used for encryption

• A unique identifier for a record in a table

• A key that is not used in normalization

What is a transitive dependency?

• A direct relationship between two attributes

• An indirect relationship where one attribute depends on another

• A relationship that does not exist

• A dependency that is always valid

Which of the following is NOT a step in converting to First Normal Form?

• Create multiple tables

• Identify the primary key

• Eliminate repeating groups

• Identify all dependencies

What is the purpose of denormalization?

• To increase data redundancy

• To ensure data integrity

• To improve processing speed

• To eliminate data anomalies

What does BCNF stand for?

• Base-Coded Normal Form

• Binary-Coded Normal Form

• Basic-Coding Normal Form

• Boyce-Codd Normal Form

What is a surrogate key?

• A key that is always visible to users

• A key that is used for encryption

• A unique identifier that is not derived from application data

• A key that is derived from the primary key

Which normal form eliminates partial dependencies?

• 3NF

• 2NF

• 4NF

• 1NF