Importance of Normalization

219 views 2 pages ~ 352 words
Get a Custom Essay Writer Just For You!

Experts in this subject field are ready to write an original essay following your instructions to the dot!

Hire a Writer

Data redundancy in connections to the database can be reduced through normalization. When talking about normalization, a number of things might be taken into account.

Some of the critical elements are listed below:

i. Dependencies that are functional

This needs to be taken into account because normalization works on a single connection at a time, finding dependencies between relations as well as normalizing relations. The first step in the procedure is to identify a connection's dependencies, after which the relationship is gradually broken apart into a collection of new relations that are dependent on the newly formed dependencies. For instance, the student database can be split up to address several tables, including the state, the city, and street as well ZIP from which they come (Kim, 1982).

ii. Normal forms

There are three kinds of normal forms associated with the relational database, with each level addressing a particular aspect of redundancy. The objective is to obtain a database on the highest normal form possible. However, getting the highest normalization form does not necessarily mean that it’s optimum for a particular database (Kim, 1982).

Denormalization Functionality

Denormalization is the process through which a normalized table is rejoining to reclaim redundancy to raise the performance of a query. The process is important because it reduces frequency in the tables hence making the queries faster. For example, after Denormalization of the example of students and their addresses as mentioned above, the table should indicate the correct addresses. Other examples can include employees and their departments as well as managers and departments (Bock & Schrage, 2002).

Possible scenarios outcomes for missing steps in the checklist

If one of the steps in the data-modeling checklist is missed, then there could be two tragic scenario outcomes. First, there could be the use of wrong names for the data, and secondly, there could be insufficient column width for the data in the tables (Bock & Schrage, 2002).


Bock, D., & Schrage, J. (2002). Denormalization guidelines for base and transaction tables. ACM SIGCSE Bulletin, 34(4), 129.

Kim, W. (1982). On optimizing an SQL-like nested query. ACM Transactions on Database Systems, 7(3), 443-469.

February 01, 2023


Number of pages


Number of words




Writer #



Expertise Electronics
Verified writer

Richard is the best writer for Data Science tasks, even if you have something really complex. I needed to do tasks on security matters and already had a draft. Sharing my ideas with Richard ended up in a perfect paper!

Hire Writer

This sample could have been used by your fellow student... Get your own unique essay on any topic and submit it by the deadline.

Eliminate the stress of Research and Writing!

Hire one of our experts to create a completely original paper even in 3 hours!

Hire a Pro