Optimizing Database Design

Many legacy systems require normalization.

Identify at least two factors that should be considered in order to produce an optimal normalized set of tables when performing normalization.

Include in your discussion a detailed example of how each factor would eliminate data redundancy.

200 words