Difference between Normalization and Normal Forms

Normalization:

Normalization is the systematic process applied on the relations to reduce the degree of redundancy.

Normalization is defined as systematic because it always gives guarantee for following properties –

  • Lossless decomposition.
  • Dependency preservation.

Continue reading

DBMS Notes for GATE 2018