<\/p>\n

\n
• It is a rule where larger tables are divided into smaller tables and they are linked using relationships.<\/li>\n
• Process of organizing data in a data base is called as Normalization.<\/li>\n
• \u00a0The purpose of Normalisation is to eliminate repetitive data and ensure that data is stored logically.<\/li>\n
• Normalization minimizes redundency from a relation or relation set.<\/li>\n
• Normalization also helps in minimizing Reuse of data.<\/li>\n
• Also helps in reduction of insertion, updation and deletion anamolies.<\/li>\n
• Relation schemas that do not meet the properties are decomposed into small relation schemas so that they can meet the desired properties.<\/li>\n
• It is a rule where larger tables are divided into smaller tables and they are linked using relationships.<\/li>\n
• Database table redundancy is reduced by using normal forms.<\/li>\n<\/ul>\n

  <\/p>\n

  \n

  \n","protected":false},"excerpt":{"rendered":"

  It is a rule where larger tables are divided into smaller tables and they are linked using relationships. Process of organizing data in a data base is called as Normalization. \u00a0The purpose of Normalisation is to eliminate repetitive data and ensure that data is stored logically. Normalization minimizes redundency from a relation or relation set. […]<\/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":[6547],"tags":[7202,18513,18514,7256,7259,7196,17376,18512,18515,7267,18516,18521,18518,17369,7262,18520,18519,17368,18522,7269,18517,18523],"class_list":["post-4827","post","type-post","status-publish","format-standard","hentry","category-sql","tag-normal-forms-in-dbms","tag-normalisation","tag-normalisation-in-dbms","tag-normalization","tag-normalization-example","tag-normalization-in-dbms","tag-normalization-in-sql","tag-normalization-sql","tag-normalize-database","tag-types-of-normalization","tag-what-is-database-normalization","tag-what-is-normalization-and-denormalization","tag-what-is-normalization-in-computer","tag-what-is-normalization-in-database","tag-what-is-normalization-in-dbms","tag-what-is-normalization-in-machine-learning","tag-what-is-normalization-in-python","tag-what-is-normalization-in-sql","tag-what-is-normalization-in-sql-server","tag-what-is-normalization-in-statistics","tag-what-is-normalization-of-data","tag-what-is-normalization-of-deviance"],"yoast_head":"\n