Week 4 Discussion 1

"Optimizing Database Design" Please respond to the following:

• 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.
• Optimal  database design recognizes proper organization of table structures and  relationships. Suggest at least two methods that can be used to improve  the design of a database system.