Posted in Information Technology & Systems, Total Reads: 569
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.