Normalization refers to a series of steps taken to ensure the most efficient relational structure of a database. The process usually involves the division of one existing database table into two or more tables and maintaining the proper relationship patterns between them. Therefore, a modification to one field in a table that is part of a normalized set of tables propagates throughout the other tables in the set using the defined relationships.
Note |
Notice the use of the word “propagate.” It does not mean that the data in the modified field physically moves to any other field. It simply means that the other tables easily reference the data because it is related to them. |