Database Normalization Quiz

Which of the following is a type of functional dependency?

• Full functional dependency

• Partial functional dependency

• Transitive dependency

• All of the above

Normalization is used to:

• Increase redundancy

• Eliminate anomalies

• Decrease clarity

• Create duplicates

Which of the following normal forms is based on the concept of removing partial dependency?

• 1NF

• 2NF

• 3NF

• BCNF

A table is in 1NF if:

• It has multivalued attributes

• It has only atomic values

• It has transitive dependency

• None of the above

BCNF is a higher version of:

• 1NF

• 2NF

• 3NF

• 4NF

Which dependency is removed in 3NF?

• Transitive

• Full

• Partial

• Multivalued

Which of the following is true about 2NF?

• It eliminates partial dependency

• It eliminates transitive dependency

• It allows multivalued attributes

• None of these

Which normal form does not allow transitive dependency?

• 1NF

• 2NF

• 3NF

• BCNF

Which of the following is NOT a goal of normalization?

• Eliminate redundancy

• Improve data integrity

• Reduce dependency

• Increase anomalies

Which of the following is related to lossless decomposition?

• Join dependency

• Functional dependency

• Multivalued dependency

• Redundancy