Optimization is accomplished as a result of a thorough investigation of the various pieces of data that will be stored within the database, in particular concentrating upon how this data is interrelated.Normalization Avoids: Duplication of Data - The same data is listed in multiple lines of the database Insert Anomaly - A record about an entity cannot be inserted into the table without first inser