<\/p>\n

\n
• Normalization<\/strong> is a process of breaking down the relations with a less attributes.<\/li>\n
• Process of arranging the data in the database is called Normalization.<\/li>\n
• To reduce the repetition from a relation or from a set of relations, normalization is used.<\/li>\n
• It is used for removing undesirable characteristics like Insertion, Update and Deletion Anamolies.<\/li>\n
• Normalization divides larger table into smaller by linking them using relationships.<\/li>\n
• To reduce the repetition from a database table, normal forms are used.<\/li>\n
• For removing anamolies from relations, we use normalization.<\/li>\n
• If the anamolies are not eliminated, it may lead to data repetition, and it can also cause data integrity and other problems when the data base grows.<\/li>\n
• For creating a good database certain rules and regulations are set in normalization.<\/li>\n<\/ul>\n

  <\/p>\n

  Steps in Normalization<\/h3>\n

  <\/p>\n","protected":false},"excerpt":{"rendered":"

  Normalization is a process of breaking down the relations with a less attributes. Process of arranging the data in the database is called Normalization. To reduce the repetition from a relation or from a set of relations, normalization is used. It is used for removing undesirable characteristics like Insertion, Update and Deletion Anamolies. Normalization divides […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"passster_activate_protection":false,"passster_protect_child_pages":"","passster_protection_type":"password","passster_password":"","passster_activate_overwrite_defaults":"","passster_headline":"","passster_instruction":"","passster_placeholder":"","passster_button":"","passster_id":"","passster_activate_misc_settings":"","passster_redirect_url":"","passster_hide":"no","passster_area_shortcode":"","gtb_hide_title":false,"gtb_wrap_title":false,"gtb_class_title":"","gtb_remove_headerfooter":false,"footnotes":""},"categories":[7157],"tags":[17375,17371,17374,7257,17372,7256,7196,17376,17373,17370,7255,17369,7262,17368],"class_list":["post-4377","post","type-post","status-publish","format-standard","hentry","category-dbms","tag-1nf-2nf-3nf-bcnf-normalization","tag-1nf-2nf-3nf-normalization","tag-1nf-2nf-3nf-normalization-in-dbms","tag-database-normalization","tag-database-normalization-forms","tag-normalization","tag-normalization-in-dbms","tag-normalization-in-sql","tag-what-is-need-of-normalization-in-dbms","tag-what-is-normalisation","tag-what-is-normalization","tag-what-is-normalization-in-database","tag-what-is-normalization-in-dbms","tag-what-is-normalization-in-sql"],"yoast_head":"\n