2. 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),...
Exclusive to subscribers. 97% yet to be discovered!
You do not have access to this resource.
Click here to request your free trial access!
Already subscribed? Log in!
The Ultimate Scientific and Technical Reference
This article is included in
Software technologies and System architectures
This offer includes:
Knowledge Base
Updated and enriched with articles validated by our scientific committees
Services
A set of exclusive tools to complement the resources
Practical Path
Operational and didactic, to guarantee the acquisition of transversal skills
Doc & Quiz
Interactive articles with quizzes, for constructive reading
Standardization process
Also in our database
Exclusive to subscribers. 97% yet to be discovered!
You do not have access to this resource.
Click here to request your free trial access!
Already subscribed? Log in!
The Ultimate Scientific and Technical Reference