Chapter 5: Normalization

Question 1

a process for evaluating and correcting table structures to minimize data redundancies

Answer 1

normalization

Question 2

produces a lower normal form

Answer 2

denormalization

Question 3

table format, no repeating groups, and PK identified

Answer 3

first normal norm

Question 4

1NF and no partial dependencies

Answer 4

Second normal form

Question 5

2NF and no transitive dependencies

Answer 5

third normal form (3NF)

Question 6

every determinant is a candidate key

Answer 6

Boyce-Codd normal form (BCNF)

Question 7

3NF and no independent multivalued dependencies

Answer 7

fourth normal form (4NF)

Question 8

derives its name from the fact that a group of multiple entries of the same type can exist for any single key attribute occurrence

Answer 8

repeating group

Question 9

make new tables to eliminate partial dependencies

Answer 9

step 1 of conversion to second normal form

Question 10

reassign corresponding dependent attribute

Answer 10

step 2 of conversion to second normal form

Question 11

make new tables to eliminate transitive dependencies

Answer 11

step 1 of conversion to third normal form

Question 12

any attribute whose value determines other values within a row

Answer 12

determinant

Question 13

reassign corresponding dependent attributes

Answer 13

step 2 of conversion to third normal form

Question 14

an attribute that cannot be further subdivided

Answer 14

atomic attribute

Question 15

refers to the level of detail represented by the values stored in a table’s row

Answer 15

granularity