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 on how each factor would eliminate data redundancy.