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.

Get Plagiarism-Free and Quality Papers Without Overpaying at Homeworkmavens.com
Solution Preview:

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.

Save time and excel in your essays and homework. Hire an essay writer for the best price for the top-notch grade you deserve.
275 words per page

You essay will be 275 words per page. Tell your writer how many words you need, or the pages.

12 pt Times New Roman

Unless otherwise stated, we use 12pt Arial/Times New Roman as the font for your paper.

Double line spacing

Your essay will have double spaced text. View our sample essays.

Any citation style

APA, MLA, Chicago/Turabian, Harvard, our writers are experts at formatting.

We Accept
Image 3