Quiz on Normalization in DBMS

What is the primary purpose of normalization in DBMS?

• To ensure data integrity

• To increase data redundancy

• To eliminate all data

• To create more complex data structures

Which of the following is NOT a standard normal form?

• Boyce-Codd Normal Form (BCNF)

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Fourth Normal Form (4NF)

A relation is in First Normal Form (1NF) if:

• It is in Second Normal Form (2NF)

• It has no partial dependencies

• It has no transitive dependencies

• It contains only atomic values in each cell

What is a partial dependency?

• A dependency that exists in 3NF

• A dependency that must exist for all attributes

• A dependency where a portion of the candidate key determines non-prime attributes

• A dependency where all attributes are prime

Which condition must be met for a relation to be in Second Normal Form (2NF)?

• It must be in First Normal Form (1NF)

• It must contain only one candidate key

• It must have at least one non-prime attribute

• It must have transitive dependencies

In Third Normal Form (3NF), which of the following is true?

• It must be in First Normal Form (1NF)

• No partial dependencies exist

• No transitive dependencies exist for non-prime attributes

• All attributes must be non-prime

What defines a transitive dependency?

• A is not a super key and B is a non-prime attribute

• A is a non-prime attribute and B is a prime attribute

• A is a candidate key and B is a prime attribute

• A is a super key and B is a non-prime attribute

Which of the following is a requirement for Boyce-Codd Normal Form (BCNF)?

• The relation must be in Second Normal Form (2NF)

• For each non-trivial functional dependency A → B, A must be a super key

• It must have at least one non-prime attribute

• It must contain no candidate keys

What is the result of normalizing a relation to 1NF?

• All attributes must be composite

• Each cell contains only one value

• There are no candidate keys

• All attributes are non-prime

Which of the following statements is true regarding candidate keys?

• They are always the same as primary keys

• They can determine both prime and non-prime attributes

• They must be a subset of all attributes

• They can only determine non-prime attributes