DBMS Normalization Quiz

Which normal form removes partial dependency?

• 1NF

• 2NF

• 3NF

• BCNF

Which normal form removes transitive dependency?

• 1NF

• 2NF

• 3NF

• 4NF

A relation is in BCNF if:

• It is in 3NF and every determinant is a candidate key

• It is in 2NF

• It has no multivalued dependency

• It has no functional dependency

Which of the following normal forms deals with multivalued dependencies?

• 2NF

• 3NF

• 4NF

• BCNF

The main purpose of normalization is to:

• Increase redundancy

• Reduce redundancy

• Increase complexity

• Reduce database size only

A table in First Normal Form (1NF) must:

• Have no repeating groups

• Remove transitive dependency

• Remove partial dependency

• Remove multivalued dependency

Which normal form removes join dependency?

• 3NF

• BCNF

• 4NF

• 5NF

If every non-key attribute depends fully on the primary key, the relation is in:

• 1NF

• 2NF

• 3NF

• BCNF

Which dependency causes transitive dependency?

• A → B and B → C

• A → B only

• B → A

• A → C only

Which of the following is NOT a normal form?

• 2NF

• 3NF

• 4NF

• 6NF