{"id":5040,"date":"2022-10-26T09:22:43","date_gmt":"2022-10-26T09:22:43","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=5040"},"modified":"2022-10-26T09:25:20","modified_gmt":"2022-10-26T09:25:20","slug":"normal-forms-in-dbms","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/normal-forms-in-dbms\/","title":{"rendered":"Normal Forms in DBMS ?"},"content":{"rendered":"<p style=\"text-align: justify;\">There are 4 types of form in Normalization :<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-5041 aligncenter\" src=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/Types-of-normal-forms-in-dbms.jpg\" alt=\"\" width=\"621\" height=\"518\" srcset=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/Types-of-normal-forms-in-dbms.jpg 621w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/Types-of-normal-forms-in-dbms-300x250.jpg 300w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/Types-of-normal-forms-in-dbms-390x325.jpg 390w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/><\/p>\n<h2 id=\"first-normal-form1nf\" style=\"text-align: justify;\"><strong>First Normal Form(1NF)\u00a0<\/strong><\/h2>\n<ul style=\"text-align: justify;\">\n<li>If a relation does not contain any multi valued attributes, then the relation is said to be in First Normal Form.<\/li>\n<li>A relation is said to be in First Normal Form if each attributes contains only single value.<\/li>\n<li>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<h2 id=\"second-normal-form2nf\" style=\"text-align: justify;\"><strong>Second Normal Form(2NF)<\/strong><\/h2>\n<ul style=\"text-align: justify;\">\n<li>A table is said to be second normal form on two conditions<\/li>\n<li>Table should be in First Normal Form(1NF).<\/li>\n<li>Any non-prime attribute is not dependent on the proper subset of the candidate key of the table.<\/li>\n<li>Non prime attribute is an attribute which is not a part of any candidate key.<\/li>\n<\/ul>\n<h2 id=\"third-normal-form3nf\" style=\"text-align: justify;\"><strong>Third Normal Form(3NF)<\/strong><\/h2>\n<ul style=\"text-align: justify;\">\n<li>A design of the table is said to be third normal form(3NF) only if<\/li>\n<li>A Table is in second normal form(2NF)<\/li>\n<li>Transitive functional dependency of non-prime attribute on any super key should be removed.<\/li>\n<li>Non prime attribute is an attribute which is not a part of any candidate key.<\/li>\n<\/ul>\n<h2 id=\"boycee-codd-normal-formbcnf\" style=\"text-align: justify;\"><strong>Boycee & Codd Normal Form(BCNF)<\/strong><\/h2>\n<ul style=\"text-align: justify;\">\n<li>An advanced version of third normal form is known as Boycee & Codd Normal Forms(BCNF).<\/li>\n<li>BCNF is stricter than third normal form.<\/li>\n<li>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<p style=\"text-align: justify;\">\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"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":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What is Normalization in DBMS ? - Normal Forms in DBMS<\/title>\n<meta name=\"description\" content=\"What is Normalization in DBMS ? - First Normal Form(1NF) - Second Normal Form(2NF) - Third Normal Form(3NF) - Boycee &amp; Codd Normal Form(BCNF)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/normal-forms-in-dbms\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is Normalization in DBMS ? - Normal Forms in DBMS\" \/>\n<meta property=\"og:description\" content=\"What is Normalization in DBMS ? - First Normal Form(1NF) - Second Normal Form(2NF) - Third Normal Form(3NF) - Boycee &amp; Codd Normal Form(BCNF)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/normal-forms-in-dbms\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-26T09:22:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-26T09:25:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/Types-of-normal-forms-in-dbms.jpg\" \/>\n<meta name=\"author\" content=\"webmaster\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webmaster\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/normal-forms-in-dbms\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/normal-forms-in-dbms\\\/\"},\"author\":{\"name\":\"webmaster\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"headline\":\"Normal Forms in DBMS ?\",\"datePublished\":\"2022-10-26T09:22:43+00:00\",\"dateModified\":\"2022-10-26T09:25:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/normal-forms-in-dbms\\\/\"},\"wordCount\":241,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/normal-forms-in-dbms\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/Types-of-normal-forms-in-dbms.jpg\",\"keywords\":[\"basic concept of normalization\",\"database normalization\",\"dbms normalization\",\"need of normalization in dbms\",\"normal forms in dbms\",\"normalization example\",\"normalization in database with example tables\",\"normalization in dbms\",\"types of normalization in dbms\",\"what is normalization in dbms\",\"what is normalization in sql\"],\"articleSection\":[\"DBMS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/normal-forms-in-dbms\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/normal-forms-in-dbms\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/normal-forms-in-dbms\\\/\",\"name\":\"What is Normalization in DBMS ? - Normal Forms in DBMS\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/normal-forms-in-dbms\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/normal-forms-in-dbms\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/Types-of-normal-forms-in-dbms.jpg\",\"datePublished\":\"2022-10-26T09:22:43+00:00\",\"dateModified\":\"2022-10-26T09:25:20+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"description\":\"What is Normalization in DBMS ? - First Normal Form(1NF) - Second Normal Form(2NF) - Third Normal Form(3NF) - Boycee & Codd Normal Form(BCNF)\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/normal-forms-in-dbms\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/normal-forms-in-dbms\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/Types-of-normal-forms-in-dbms.jpg\",\"contentUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/Types-of-normal-forms-in-dbms.jpg\",\"width\":621,\"height\":518},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/\",\"name\":\"Wikitechy\",\"description\":\"Interview Questions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\",\"name\":\"webmaster\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"caption\":\"webmaster\"},\"sameAs\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\"],\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/author\\\/webmaster\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is Normalization in DBMS ? - Normal Forms in DBMS","description":"What is Normalization in DBMS ? - First Normal Form(1NF) - Second Normal Form(2NF) - Third Normal Form(3NF) - Boycee & Codd Normal Form(BCNF)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/normal-forms-in-dbms\/","og_locale":"en_US","og_type":"article","og_title":"What is Normalization in DBMS ? - Normal Forms in DBMS","og_description":"What is Normalization in DBMS ? - First Normal Form(1NF) - Second Normal Form(2NF) - Third Normal Form(3NF) - Boycee & Codd Normal Form(BCNF)","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/normal-forms-in-dbms\/","og_site_name":"Wikitechy","article_published_time":"2022-10-26T09:22:43+00:00","article_modified_time":"2022-10-26T09:25:20+00:00","og_image":[{"url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/Types-of-normal-forms-in-dbms.jpg","type":"","width":"","height":""}],"author":"webmaster","twitter_card":"summary_large_image","twitter_misc":{"Written by":"webmaster","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/normal-forms-in-dbms\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/normal-forms-in-dbms\/"},"author":{"name":"webmaster","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"headline":"Normal Forms in DBMS ?","datePublished":"2022-10-26T09:22:43+00:00","dateModified":"2022-10-26T09:25:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/normal-forms-in-dbms\/"},"wordCount":241,"commentCount":0,"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/normal-forms-in-dbms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/Types-of-normal-forms-in-dbms.jpg","keywords":["basic concept of normalization","database normalization","dbms normalization","need of normalization in dbms","normal forms in dbms","normalization example","normalization in database with example tables","normalization in dbms","types of normalization in dbms","what is normalization in dbms","what is normalization in sql"],"articleSection":["DBMS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/normal-forms-in-dbms\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/normal-forms-in-dbms\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/normal-forms-in-dbms\/","name":"What is Normalization in DBMS ? - Normal Forms in DBMS","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/normal-forms-in-dbms\/#primaryimage"},"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/normal-forms-in-dbms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/Types-of-normal-forms-in-dbms.jpg","datePublished":"2022-10-26T09:22:43+00:00","dateModified":"2022-10-26T09:25:20+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"description":"What is Normalization in DBMS ? - First Normal Form(1NF) - Second Normal Form(2NF) - Third Normal Form(3NF) - Boycee & Codd Normal Form(BCNF)","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/normal-forms-in-dbms\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/normal-forms-in-dbms\/#primaryimage","url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/Types-of-normal-forms-in-dbms.jpg","contentUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/Types-of-normal-forms-in-dbms.jpg","width":621,"height":518},{"@type":"WebSite","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website","url":"https:\/\/www.wikitechy.com\/interview-questions\/","name":"Wikitechy","description":"Interview Questions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wikitechy.com\/interview-questions\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4","name":"webmaster","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","caption":"webmaster"},"sameAs":["https:\/\/www.wikitechy.com\/interview-questions"],"url":"https:\/\/www.wikitechy.com\/interview-questions\/author\/webmaster\/"}]}},"_links":{"self":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/5040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/comments?post=5040"}],"version-history":[{"count":3,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/5040\/revisions"}],"predecessor-version":[{"id":5044,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/5040\/revisions\/5044"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=5040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=5040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=5040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}