Normalization: is a gradual process of removing redundancies of attributes in a data structure. The condition of the data at completion of each step is described as a "normal form." Normalization is usually considered to be a good way to design a database, however it involves high CPU time to process a task or query.
|
Denormalization: is the reverse of normalization wherein the emphasis is on increasing redundancies. This is done for performance enhancement and reduced query time. |