Database Normalization| 1NF, 2NF,
3NF & Denormalization|
What is normalization in database design? - Answer-Normalization is a process for
evaluating and correcting table structures to minimize data redundancies and reduce
the likelihood of data anomalies.
What are the first three normal forms in normalization? - Answer-First normal form
(1NF), Second normal form (2NF), and Third normal form (3NF).
What is the highest normal form typically needed in business database design? -
Answer-Third normal form (3NF).
What is denormalization? - Answer-Denormalization produces a lower normal form,
increasing performance but resulting in greater data redundancy.
When is normalization commonly used? - Answer-Normalization is used when
designing a new database structure or analyzing the relationship among attributes
within each entity.
What is the main goal of normalization? - Answer-To eliminate data anomalies by
removing unnecessary or unwanted data redundancies.
What is a partial dependency? - Answer-A partial dependency exists when there is a
functional dependence where the determinant is only part of the primary key.
What does a transitive dependency indicate? - Answer-A transitive dependency exists
when an attribute is dependent on another attribute that is not part of the primary key.
What are the characteristics of a well-formed relation? - Answer-Each table represents
a single subject, each row/column intersection contains only one value, all nonprime
attributes are dependent on the primary key, and no anomalies exist.
What does the first normal form (1NF) require? - Answer-1NF requires that all key
attributes are defined, there are no repeating groups, and all attributes are dependent
on the primary key.
What is the first step in converting to first normal form (1NF)? - Answer-Eliminate the
repeating groups by ensuring each cell has a single value.
