{"id":4377,"date":"2022-05-27T06:39:14","date_gmt":"2022-05-27T06:39:14","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=4377"},"modified":"2022-06-03T09:22:06","modified_gmt":"2022-06-03T09:22:06","slug":"what-is-normalization-in-dbms","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization-in-dbms\/","title":{"rendered":"What is Normalization in DBMS ?"},"content":{"rendered":"<p style=\"text-align: justify;\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-4378\" src=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/what-is-normalization.jpg\" alt=\"\" width=\"807\" height=\"432\" srcset=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/what-is-normalization.jpg 807w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/what-is-normalization-300x161.jpg 300w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/what-is-normalization-768x411.jpg 768w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/what-is-normalization-390x209.jpg 390w\" sizes=\"(max-width: 807px) 100vw, 807px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\"><strong>Normalization<\/strong> is a process of breaking down the relations with a less attributes.<\/li>\n<li style=\"text-align: justify;\">Process of arranging the data in the database is called Normalization.<\/li>\n<li style=\"text-align: justify;\">To reduce the repetition from a relation or from a set of relations, normalization is used.<\/li>\n<li style=\"text-align: justify;\">It is used for removing undesirable characteristics like Insertion, Update and Deletion Anamolies.<\/li>\n<li style=\"text-align: justify;\">Normalization divides larger table into smaller by linking them using relationships.<\/li>\n<li style=\"text-align: justify;\">To reduce the repetition from a database table, normal forms are used.<\/li>\n<li style=\"text-align: justify;\">For removing anamolies from relations, we use normalization.<\/li>\n<li style=\"text-align: justify;\">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<li>For creating a good database certain rules and regulations are set in normalization.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-4432\" src=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/database-normalization.png\" alt=\"\" width=\"1570\" height=\"581\" srcset=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/database-normalization.png 1570w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/database-normalization-300x111.png 300w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/database-normalization-1024x379.png 1024w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/database-normalization-768x284.png 768w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/database-normalization-1536x568.png 1536w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/database-normalization-390x144.png 390w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/database-normalization-820x303.png 820w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/database-normalization-1180x437.png 1180w\" sizes=\"(max-width: 1570px) 100vw, 1570px\" \/><\/p>\n<h3 id=\"steps-in-normalization\">Steps in Normalization<\/h3>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-4434\" src=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/steps-in-normalization.png\" alt=\"\" width=\"1118\" height=\"1116\" srcset=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/steps-in-normalization.png 1118w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/steps-in-normalization-300x300.png 300w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/steps-in-normalization-1024x1022.png 1024w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/steps-in-normalization-150x150.png 150w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/steps-in-normalization-768x767.png 768w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/steps-in-normalization-80x80.png 80w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/steps-in-normalization-390x389.png 390w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/steps-in-normalization-820x819.png 820w\" sizes=\"(max-width: 1118px) 100vw, 1118px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&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":[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":"<!-- 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 ? - Database Normalization - Wikitechy<\/title>\n<meta name=\"description\" content=\"What is Normalization in DBMS ? - Normalization is a process of breaking down the relations with a less attributes.\" \/>\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\/what-is-normalization-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 ? - Database Normalization - Wikitechy\" \/>\n<meta property=\"og:description\" content=\"What is Normalization in DBMS ? - Normalization is a process of breaking down the relations with a less attributes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization-in-dbms\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-27T06:39:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-03T09:22:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/what-is-normalization.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\\\/what-is-normalization-in-dbms\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization-in-dbms\\\/\"},\"author\":{\"name\":\"webmaster\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"headline\":\"What is Normalization in DBMS ?\",\"datePublished\":\"2022-05-27T06:39:14+00:00\",\"dateModified\":\"2022-06-03T09:22:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization-in-dbms\\\/\"},\"wordCount\":132,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization-in-dbms\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/what-is-normalization.jpg\",\"keywords\":[\"1nf 2nf 3nf bcnf normalization\",\"1nf 2nf 3nf normalization\",\"1nf 2nf 3nf normalization in dbms\",\"database normalization\",\"database normalization forms\",\"normalization\",\"normalization in dbms\",\"normalization in sql\",\"what is need of normalization in dbms\",\"what is normalisation\",\"what is normalization\",\"what is normalization in database\",\"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\\\/what-is-normalization-in-dbms\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization-in-dbms\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization-in-dbms\\\/\",\"name\":\"What is Normalization in DBMS ? - Database Normalization - Wikitechy\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization-in-dbms\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization-in-dbms\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/what-is-normalization.jpg\",\"datePublished\":\"2022-05-27T06:39:14+00:00\",\"dateModified\":\"2022-06-03T09:22:06+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"description\":\"What is Normalization in DBMS ? - Normalization is a process of breaking down the relations with a less attributes.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization-in-dbms\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization-in-dbms\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/what-is-normalization.jpg\",\"contentUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/what-is-normalization.jpg\",\"width\":807,\"height\":432},{\"@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 ? - Database Normalization - Wikitechy","description":"What is Normalization in DBMS ? - Normalization is a process of breaking down the relations with a less attributes.","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\/what-is-normalization-in-dbms\/","og_locale":"en_US","og_type":"article","og_title":"What is Normalization in DBMS ? - Database Normalization - Wikitechy","og_description":"What is Normalization in DBMS ? - Normalization is a process of breaking down the relations with a less attributes.","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization-in-dbms\/","og_site_name":"Wikitechy","article_published_time":"2022-05-27T06:39:14+00:00","article_modified_time":"2022-06-03T09:22:06+00:00","og_image":[{"url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/what-is-normalization.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\/what-is-normalization-in-dbms\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization-in-dbms\/"},"author":{"name":"webmaster","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"headline":"What is Normalization in DBMS ?","datePublished":"2022-05-27T06:39:14+00:00","dateModified":"2022-06-03T09:22:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization-in-dbms\/"},"wordCount":132,"commentCount":0,"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization-in-dbms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/what-is-normalization.jpg","keywords":["1nf 2nf 3nf bcnf normalization","1nf 2nf 3nf normalization","1nf 2nf 3nf normalization in dbms","database normalization","database normalization forms","normalization","normalization in dbms","normalization in sql","what is need of normalization in dbms","what is normalisation","what is normalization","what is normalization in database","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\/what-is-normalization-in-dbms\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization-in-dbms\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization-in-dbms\/","name":"What is Normalization in DBMS ? - Database Normalization - Wikitechy","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization-in-dbms\/#primaryimage"},"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization-in-dbms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/what-is-normalization.jpg","datePublished":"2022-05-27T06:39:14+00:00","dateModified":"2022-06-03T09:22:06+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"description":"What is Normalization in DBMS ? - Normalization is a process of breaking down the relations with a less attributes.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization-in-dbms\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization-in-dbms\/#primaryimage","url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/what-is-normalization.jpg","contentUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/what-is-normalization.jpg","width":807,"height":432},{"@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\/4377","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=4377"}],"version-history":[{"count":6,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4377\/revisions"}],"predecessor-version":[{"id":4435,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4377\/revisions\/4435"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=4377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=4377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=4377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}