Skip to main content

NORMALIZATION IN RDBMS

WHAT IS NORMALIZATION??


Database Normalization is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion Anomalies. It is a multi-step process that puts data into tabular form by removing duplicated data from the relation tables.
Normalization is used for mainly two purpose,
  • Eliminating redundant(useless) data.
  • Ensuring data dependencies make sense i.e data is logically stored

NORMALIZATION RULE
Normalization rule are divided into following normal form.
  1. First Normal Form
  2. Second Normal Form
  3. Third Normal Form
  4. BCNF
Below is a basic example of normalization upto third normal form which I did as part of my class assignment.

Comments

Post a Comment