Chapter 6

Question 1

What is Normalization?

Answer 1

*Evaluating and correcting table structures to minimize data redundancies

*Reduces data anomalies

*Assigns attributes to tables based on determination

Question 2

What is the need for Normalization?

Answer 2

Used while designing a new database structure

Analyzes the relationship among the attributes within each entity

Determines if the structure can be improved

Improves the existing data structure and creates an appropriate database design

Question 3

What are the characteristics of 1NF?

Answer 3

Table format, no repeating groups, and PK identified

Question 4

What are the characteristics of 2NF?

Answer 4

1NF and no partial dependencies

Question 5

What are the characteristics of 3NF?

Answer 5

2F and no transitive dependencies

Question 6

What are the steps of Conversion to First Normal Form?

Answer 6

Eliminate the repeating groups
Identify the primary key
Identify all dependencies

Question 7

What are the steps of Conversion to Second Normal Form?

Answer 7

Make new tables to eliminate partial dependencies Reassign corresponding dependent attributes

Question 8

What are the steps of Conversion to Third Normal Form?

Answer 8

Make new tables to eliminate transitive dependencies

Determinant: Any attribute whose value determinesother values within a row

Question 9

What are the Database Design Goals?

Answer 9

Creation of normalized relations

Number of database tables expands when tables are decomposed to conform to normalization requirements

Processing requirements and speed

Question 10

What does Denormalization mean? And what does it imply?

Answer 10

Produces a lower normal form.

Results in increased performance and greater data redundancy