Skip to content Skip to main navigation Skip to footer

Normalization in Database

Objectives

  • Define the purpose of normalization in database models
Normalization in Database

Purpose of the Normalization in Database

  • Think about storing your friends’ phone numbers in three different places: your address book, your cell phone, and a sheet of paper that you have taped to your refrigerator.
  • It’s a lot of work if a friend changes his/her phone number.
  • You have to change it in your address book, cell phone, and the sheet of paper taped to your refrigerator.
  • What happens if data is stored in more than one place in a database?
  • What if someone changes the information in one place and not the other—how do you know which information is correct?
  • Redundancy like this causes unnecessary problems in a database.
  • Normalization is a process that is used to eliminate these kinds of problems.
  • One of your goals as a database designer is to “store information in one place and in the best possible place“.
  • If you follow the rules of normalization, you will achieve this goal.

Normalization in Database

  • Going through the above given example, it’s safe to assume that database normalization is a technique of organizing the data in the database.
  • Is an approach of well-organizing tables to eliminate data redundancy.
  • It is a multi-step process that organizes data, and removing duplication from the database tables.
  • In short, database normalization is used for mainly two purposes:
    • Eliminating redundant (repetitive) data.
    • Ensuring data dependencies make sense.

Normalization Rule

Normalization rules are divided into the following normal forms:

Terminology

Key terms used in this article included:

  • Normalization
  • Redundancy

Summary

In this article, you should have learned how to:

  • Define the purpose of normalization models

Was This Article Helpful?

0
Related Articles
0 Comments

There are no comments yet

Leave a comment

Your email address will not be published. Required fields are marked *