Posted in Information Technology & Systems, Total Reads: 1107

Definition: Normalization

Normalization is the process of rearranging & organizing the values, fields and tables in a relational database management system. It involves dividing large tables into smaller tables and defining relationships between them. The objective is to remove any unwanted information from the database.

Normalization is done so that additions, deletions, and modifications of a field in a table can be made in just one table and then taken over through the rest of the database using the defined relationships. Normalization generally involves splitting existing tables into multiple ones and rejoining and linking them each time a query (a request to get specific information) is issued.  

Normalization helps to maintain data integrity, improves storage efficiency and scalability.

Normalization is of three types:-

  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)

Browse the definition and meaning of more terms similar to Normalization. The Management Dictionary covers over 7000 business concepts from 6 categories.

Search & Explore : Management Dictionary

Share this Page on:
Facebook ShareTweetShare on G+Share on Linkedin