- Define the purpose of normalization in database models
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 rules are divided into the following normal forms:
Key terms used in this article included:
In this article, you should have learned how to:
- Define the purpose of normalization models