Database Normalization
Overview
In this tutorial, we will learn about database normalization. Normalization is the process of refining a database design to ensure that each independent piece of information is in one place. Normalizing the database tables removes data redundancy. The process removes data anomalies.
Normalization makes it possible to access data more flexibly and eliminates the possibility that
inappropriate modifications will take place that will make the data inconsistent.
Normalization of a complex table often takes it through a decomposition process into a set of smaller tables. This process removes undesirable multi-valued attributes, repeating groups within rows, and data redundancy within columns. Repeating groups and multi-valued
attributes are essentially tables within tables.
Three Normal Forms
Normalization ensures database integrity. The three normal forms are the most commonly used in this process.
https://www.testingdocs.com/database-normal-forms/
Advantages of Normalization
Data normalization can be an expensive process in time and resources; however, besides the advantages
derived from the purposes of normalization, other advantages need to be taken into account:
ER Diagrams
Developing ERDs is much easier when the data is normalized and the tables, columns, and relationships are pre-determined. Normalizing the data makes it easier to modify a single object property.
Joins
Joins can be very expensive and proper normalization can improve relationships between
tables and minimize the amount of data having to be searched.
Optimization
Due to the better joins, the optimizer has fewer indexes per table, so it does not have to consider as many execution plans. This helps with retrievals and updates.
—
MySQL Tutorials
MySQL Tutorials on this website:
https://www.testingdocs.com/mysql-tutorials-for-beginners/
For more information on MySQL Database:
