Why do We Need Normalization.

by Hongde H
The article I read was about why we need database normalization, an important part of database design that helps reduce redundancy and dependency. It greatly helps dividing large table into smaller ones for less redundancy and better defining the relationship between the data. In other words, it isolates data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.

In the article “Why You Need Database Normalization”, author, Michelle A. Poolet explained the importance of having database normalization in a very specific way. She talked about how would data normalization makes data and information more meaningful and useful. For example, a data item (10/23/2012) can mean nothing to us but if we associate it with other data items, such as deadline of the project, we make it more useful and meaningful.

Moreover, she also talked about how to apply normalization in businesses. She stated the need to conduct research at your company before we can begin to normalize a database. The need to perform a requirements analysis that will identify policies and procedures and list the business rules for them.

She also explained the relationships between data and how they pertain to the data we are working with, primary and foreign key, and how to progress from 1NF to 3NF. Which is what we mainly learned during the week.

I picked this article not because it is closely related to what we are lectured in the class but it will also definitely help all of us to strengthen what we learned about normalization. Therefore, I’d love to share this article with you all. However, this post is only a summary of the article, I strongly recommend everyone to take a look at the original article. It will also help you finishing the assignment and upcoming test.

Source: Michelle A. Poolet (Jun 25, 2009) “Why do We Need Database Normalization”

Retrieve From: http://www.sqlmag.com/article/performance/sql-by-design-why-you-need-database-normalization

4 thoughts on “Why do We Need Normalization.

  • October 21, 2012 at 3:47 pm
    Permalink

    Great post Allan. It’s very similar to the article I chose this week, but yours goes more into detail about normalization and why it is crucial for database systems. I wasn’t aware that normalization had four goals, but I’m glad to learn this now. Thank you for sharing, it gave me a good overview of what we’ve learned this past week and helped me to understand normalization better.

  • October 21, 2012 at 5:19 pm
    Permalink

    Very good post, We just learned about normalization last week. This post reminds me how important the normalization is. Data itself is meaningless, we are the one who makes data more useful and meaningful. The article is very specifically going over in details in why do we need normalization and how to do normalization.

  • October 21, 2012 at 10:14 pm
    Permalink

    Nice post. Normalization is very important in database management; it’s the process of efficiently organizing data in a database. We use normalization to eliminate redundant data and ensure data dependencies make sense so we can reduce the amount of space a database uses and ensure that data is stored logically. Thanks for sharing

  • October 22, 2012 at 12:20 am
    Permalink

    I actually read the same article. Data Normalization is important- she mentions that it is most important when dealing with online transactional processing data. Data Normalization helps to reduce redundant data and allows data to be modified without altering the entire database.

Comments are closed.