Rob & Coronell - Chapter 6

Question 1

What are two reasons to practice data normalization?

Answer 1

1. So that you can recognize a poor table structure

2. To produce a good table

Question 2

What is normalization?

Answer 2

A process for evaluating and correcting table structures to minimize data redunandcies, thereby reducing the likelihood of data anomalies.

Question 3

Why is the highest level of normalization not always the most desired level?

Answer 3

The higher the normal form, the more relational join operations are required to produce an output: can reduce efficiency and speed for the end-user

Question 4

What is denormalization?

Answer 4

Make your database less normalized to increase performance requirements.

By product: more data redundancy.