Understanding Database Normalization

What is the primary purpose of database normalization?

• To speed up data retrieval

• To structure data to avoid redundancy

• To protect against bad data

• To simplify complex topics

Which of the following is NOT a violation of First Normal Form?

• Storing different data types in one column

• Using row order to convey information

• Using repeating groups in a table

• Having a primary key for each table

What does Second Normal Form specifically focus on?

• Removing transitive dependencies

• Eliminating redundant data

• Dependency on the entire primary key

• Ensuring all attributes depend only on the primary key

What is a deletion anomaly?

• Duplicate data existing in multiple places in a database

• Inability to add new data without existing related data

• Loss of all data related to an entity when one data item is removed

• Incorrect data following an update operation

Which form is described as every attribute in a table depending on the key, the whole key, and nothing but the key?

• Third Normal Form

• Second Normal Form

• Boyce-Codd Normal Form

• First Normal Form

What type of dependency is forbidden under Third Normal Form?

• Functional dependency

• Multivalued dependency

• Transitive dependency

• Partial dependency

Which scenario describes a transitive dependency?

• An attribute depends only on part of a composite key

• An attribute depends on the whole primary key

• An attribute depends on another attribute which itself depends on the primary key

• Multiple attributes depend on a composite key

Which Normal Form deals with multivalued dependencies?

• Fifth Normal Form

• Fourth Normal Form

• Third Normal Form

• Second Normal Form

What does it mean if a table is in Fifth Normal Form?

• It has no multivalued dependencies

• It cannot be decomposed into smaller tables without loss of data

• It is free from update anomalies

• It can be reconstructed by joining smaller tables

What problem does Fourth Normal Form address?

• All forms of data redundancy

• Multivalued dependencies independent of the primary key

• Transitive dependencies

• Partial dependencies