CIS 376 Week 2 Discussion
Normalization is a key concept in creating a database. Define normalization and list two anomalies that can occur if a database table is not properly normalized. Be sure to include the issues that could affect the data if their anomaly is not fixed.
Normalization is a data design technique that involves the restructuring of a relational database in accordance with the series of so called normal forms. Its sole purpose in SQL is to reduce repetition in data, improve the integrity of the data, and eliminate undesired characteristics like Update and Deletion Anomalies. Deletion anomalies happen when the deletion of unwanted information causes desired information to be deleted as well. Insertion anomalies happen when the deletion of unwanted information causes desired information to be deleted as well. The 6 database normal forms include the First Normal Form (1NF) to the Sixth Normal Form (6NF). In most practical applications, the 3rdNormal Form achieves the best normalization. There are several issues that could affect the data if their anomaly is not fixed. Organizations can suffer from customer data fragmentation. This can result to inconsistency and redundancy in data. Data inconsistency results from situations where there are multiple tables within a database that deal with the same data but may receive it in different inputs. It differs from data redundancy as it focuses on problems within the content of the database rather than the structure and design.