Session 5 _Quiz

What are the benefits of normalization?

• Reducing data redundancy

• Improving data integrity

• Making data easier to update and delete

• All of the above

Which normal form is designed to eliminate partial dependencies?

• First normal form (1NF)

• Second normal form (2NF)

• Third normal form (3NF)

• Boyce-Codd normal form (BCNF)

What is database normalization?

• The method used to speed up database queries.

• A process of organizing data to reduce redundancy and improve data integrity.

• The act of encrypting all data in a database.

• The process of creating backup copies of a database.

What is the primary goal of Third Normal Form (3NF)?

• Eliminating all repeating groups in a table.

• Eliminating transitive dependencies in a table.

• Ensuring that all non-key attributes are functionally dependent on the primary key.

• Breaking a table into smaller sub-tables to avoid redundancy.

What is a candidate key?

• An attribute that is not unique in a table.

• An attribute that can be used as a primary key.

• An attribute that is always a foreign key.

• An attribute with a long character length.