1What is the purpose of database normalization?
To evaluate and correct table structures to minimize data redundancies.
2What is the goal of normalization?
To reduce data anomalies.
3Through what stages does normalization work?
Normalization works through a series of stages called normal forms: 1NF, 2NF, 3NF.
4Which normal form is typically sufficient for most business database designs?
Third Normal Form (3NF).
5Which two techniques are used together to produce a good database design?
Normalization and ER modeling.
6What is a dependency diagram?
A diagram that depicts all dependencies within a table structure, helping visualize relationships among attributes.
7What is a determinant in a table?
Any attribute whose value determines other values within a row.
8What is Un-Normalized Form (UNF)?
A table containing repeating groups where multiple entries of the same type exist for a single key attribute occurrence.
9What is the first step to convert a table to 1NF?
Eliminate repeating groups by presenting data in tabular format with single values in each cell and no nulls.
10What is the second step to convert a table to 1NF?
Identify the primary key that uniquely identifies the attribute value.
11What is the third step to convert a table to 1NF?
Identify all dependencies.
12What defines a table in 1NF?
All key attributes are defined, there are no repeating groups, and all attributes are dependent on the primary key.
13What is a partial dependency?
A dependency based on only part of the primary key.
14What is the first step to convert a table to 2NF?
Write each key component on a separate line, making each component a key in a new table.
15What is the second step to convert a table to 2NF?
Assign the corresponding dependent attributes to the new tables.
16What defines a table in 2NF?
It is in 1NF and includes no partial dependencies.
17What is a transitive dependency?
A situation where a non-key attribute determines another non-key attribute.
18What is the first step to convert a table to 3NF?
Identify each new determinant in transitive dependencies and make it the primary key of a new table.
19What is the second step to convert a table to 3NF?
Identify the dependent attributes for each new determinant and name the new table.
20What is the third step to convert a table to 3NF?
Remove the dependent attributes in transitive relationships from the original tables.
21What defines a table in 3NF?
It is in 2NF and contains no transitive dependencies.