Standardization process

This process is applied to the database schema.

• Why?

  The purpose of normalizing a relational schema is to prevent the database from containing redundant data. It's obvious that the same data stored several times in the database can cause anomalies during updates.

  For example, if a supplier's name is stored in both the PRODUCTS table and the SUPPLIERS table, the sales manager could update the SUPPLIERS table and fail to reflect the change in the PRODUCTS table, resulting in an inconsistent database.

• Who and when?

  Standardization is a process implemented by the database designer when drawing up the schema. By structuring data according to certain rules (normal forms),...