Improperly Normalized Accounting Tables | MyPaperHub

In accounting, normalization helps in splitting relations into well-structured relations that allow users to insert, delete or update tuples without introducing any database inconsistencies. Normalization prevents many problems that may occur when a user tries to load an integrated conceptual model into the database management systems. The problems are called anomalies and include; update, deletion and insertion anomalies.

            An update anomaly is a data inconsistency that results from data redundancy and a possible partial update (Hall, 2015). A deletion anomaly is an unintended data loss of accounting information while doing away with some other data. In this case, the loss happens without the discretion of the user. Combining data from different categories may result in this anomaly while one is doing away with one category of data only to delete the whole information. Deletion anomaly can result in internal loss or critical accounting records and the destruction of the audit trail. Because the deletion anomaly may go undetected, the user may be unaware of the loss of important data until it is too late. An insertion anomaly takes place when a user is not in a position to add data to the database due to the absence of the intended data.

The insertion and update anomalies would create a record keeping and operational problems for the firm. However, use flawed databases design that prevents the insertion of records, or requires the user to perform excessive updates, would attract attention quickly. The presence of the deletion anomaly is less conspicuous, but potentially more serious from an accounting perspective. Database management can be deployed to solve all the anomalies as data will be well grouped making it access, update and insert accounting data into the tables. DBMS will also solve the problem of improperly normalized accounting tables.

Additional articles


Why do u think the movie was band was it because of Korea or Americas doing ?

Banning of the movie “The Interview” Seth Rogen as well as Evan Goldberg's Kim comedy "The Interview" on the assassination of Jong-un death has been the subject of contention. This film was initially scheduled to be released in October, althou...Why-do-u-think-the-movie-was-band-was-it-because-of-Korea-or-Americas-doing-? …

Read Article
Should The US Have Attacked Iraq In 2003

The US-led the invasion of Iraq in 2003 overthrowing the government of Saddam Hussein in a span of three weeks. Even though the proponents of this attack by the U.S. presents arguments on how the war liberated Iraqis from the human rights abuses o...Should-The-US-Have-Attacked-Iraq-In-2003 …

Read Article
7 Buy Assignment Tips You Should Know In 2018

From the first moment you are given that assignment, your mind will already be made up on whether you will do it yourself or buy an assignment from a writing company. Writing is a skill that many students have not mastered. On top of that, many s...7-Buy-Assignment-Tips-You-Should-Know-In-2018- …

Read Article
Let's give your paper the attention it deserves