There are 4 types of form in Normalization :<\/p>\n

<\/p>\n

First Normal Form(1NF)\u00a0<\/strong><\/h2>\n

\n
• If a relation does not contain any multi valued attributes, then the relation is said to be in First Normal Form.<\/li>\n
• A relation is said to be in First Normal Form if each attributes contains only single value.<\/li>\n
• Rule of First normal form states that an attribute of a table cannot have multiple values. It can have only single values.<\/li>\n<\/ul>\n

  Second Normal Form(2NF)<\/strong><\/h2>\n

  \n
  • A table is said to be second normal form on two conditions<\/li>\n
  • Table should be in First Normal Form(1NF).<\/li>\n
  • Any non-prime attribute is not dependent on the proper subset of the candidate key of the table.<\/li>\n
  • Non prime attribute is an attribute which is not a part of any candidate key.<\/li>\n<\/ul>\n

    Third Normal Form(3NF)<\/strong><\/h2>\n

    \n
    • A design of the table is said to be third normal form(3NF) only if<\/li>\n
    • A Table is in second normal form(2NF)<\/li>\n
    • Transitive functional dependency of non-prime attribute on any super key should be removed.<\/li>\n
    • Non prime attribute is an attribute which is not a part of any candidate key.<\/li>\n<\/ul>\n

      Boycee & Codd Normal Form(BCNF)<\/strong><\/h2>\n

      \n
      • An advanced version of third normal form is known as Boycee & Codd Normal Forms(BCNF).<\/li>\n
      • BCNF is stricter than third normal form.<\/li>\n
      • A table is said to be in BCNF if it is already in 3NF and every functional dependency should be the super key of the table.<\/li>\n<\/ul>\n

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

        There are 4 types of form in Normalization : First Normal Form(1NF)\u00a0 If a relation does not contain any multi valued attributes, then the relation is said to be in First Normal Form. A relation is said to be in First Normal Form if each attributes contains only single value. Rule of First normal form […]<\/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":[19008,7257,19007,19009,7202,7259,7261,7196,7279,7262,17368],"class_list":["post-5040","post","type-post","status-publish","format-standard","hentry","category-dbms","tag-basic-concept-of-normalization","tag-database-normalization","tag-dbms-normalization","tag-need-of-normalization-in-dbms","tag-normal-forms-in-dbms","tag-normalization-example","tag-normalization-in-database-with-example-tables","tag-normalization-in-dbms","tag-types-of-normalization-in-dbms","tag-what-is-normalization-in-dbms","tag-what-is-normalization-in-sql"],"yoast_head":"\n