{"id":4827,"date":"2022-08-20T07:27:08","date_gmt":"2022-08-20T07:27:08","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=4827"},"modified":"2022-08-20T07:27:08","modified_gmt":"2022-08-20T07:27:08","slug":"what-is-normalization-in-sql","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-normalization-in-sql\/","title":{"rendered":"What is Normalization in SQL ?"},"content":{"rendered":"<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-4829 aligncenter\" src=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/08\/database-normalization-.png\" alt=\"\" width=\"831\" height=\"320\" srcset=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/08\/database-normalization-.png 831w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/08\/database-normalization--300x116.png 300w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/08\/database-normalization--768x296.png 768w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/08\/database-normalization--390x150.png 390w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/08\/database-normalization--820x316.png 820w\" sizes=\"(max-width: 831px) 100vw, 831px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">It is a rule where larger tables are divided into smaller tables and they are linked using relationships.<\/li>\n<li style=\"text-align: justify;\">Process of organizing data in a data base is called as Normalization.<\/li>\n<li style=\"text-align: justify;\">\u00a0The purpose of Normalisation is to eliminate repetitive data and ensure that data is stored logically.<\/li>\n<li>Normalization minimizes redundency from a relation or relation set.<\/li>\n<li>Normalization also helps in minimizing Reuse of data.<\/li>\n<li>Also helps in reduction of insertion, updation and deletion anamolies.<\/li>\n<li>Relation schemas that do not meet the properties are decomposed into small relation schemas so that they can meet the desired properties.<\/li>\n<li>It is a rule where larger tables are divided into smaller tables and they are linked using relationships.<\/li>\n<li>Database table redundancy is reduced by using normal forms.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-4828 aligncenter\" src=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/08\/normalized-database-example.png\" alt=\"\" width=\"800\" height=\"400\" srcset=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/08\/normalized-database-example.png 800w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/08\/normalized-database-example-300x150.png 300w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/08\/normalized-database-example-768x384.png 768w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/08\/normalized-database-example-390x195.png 390w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\">\n<p style=\"text-align: justify;\">\n","protected":false},"excerpt":{"rendered":"<p>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. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"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":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What is Normalization in SQL - DBMS Normalization - Wikitechy<\/title>\n<meta name=\"description\" content=\"What is Normalization in SQL ? - It is a rule where larger tables are divided into smaller tables and they are linked using relationships.\" \/>\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\/sql\/what-is-normalization-in-sql\/\" \/>\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 SQL - DBMS Normalization - Wikitechy\" \/>\n<meta property=\"og:description\" content=\"What is Normalization in SQL ? - It is a rule where larger tables are divided into smaller tables and they are linked using relationships.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-normalization-in-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-20T07:27:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/08\/database-normalization-.png\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-normalization-in-sql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-normalization-in-sql\\\/\"},\"author\":{\"name\":\"webmaster\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"headline\":\"What is Normalization in SQL ?\",\"datePublished\":\"2022-08-20T07:27:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-normalization-in-sql\\\/\"},\"wordCount\":127,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-normalization-in-sql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/database-normalization-.png\",\"keywords\":[\"normal forms in dbms\",\"normalisation\",\"normalisation in dbms\",\"normalization\",\"normalization example\",\"normalization in dbms\",\"normalization in sql\",\"normalization sql\",\"normalize database\",\"types of normalization\",\"what is database normalization\",\"what is normalization and denormalization\",\"what is normalization in computer\",\"what is normalization in database\",\"what is normalization in dbms\",\"what is normalization in machine learning\",\"what is normalization in python\",\"what is normalization in sql\",\"what is normalization in sql server\",\"what is normalization in statistics\",\"what is normalization of data\",\"what is normalization of deviance\"],\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-normalization-in-sql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-normalization-in-sql\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-normalization-in-sql\\\/\",\"name\":\"What is Normalization in SQL - DBMS Normalization - Wikitechy\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-normalization-in-sql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-normalization-in-sql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/database-normalization-.png\",\"datePublished\":\"2022-08-20T07:27:08+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"description\":\"What is Normalization in SQL ? - It is a rule where larger tables are divided into smaller tables and they are linked using relationships.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-normalization-in-sql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-normalization-in-sql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/database-normalization-.png\",\"contentUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/database-normalization-.png\",\"width\":831,\"height\":320},{\"@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 SQL - DBMS Normalization - Wikitechy","description":"What is Normalization in SQL ? - It is a rule where larger tables are divided into smaller tables and they are linked using relationships.","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\/sql\/what-is-normalization-in-sql\/","og_locale":"en_US","og_type":"article","og_title":"What is Normalization in SQL - DBMS Normalization - Wikitechy","og_description":"What is Normalization in SQL ? - It is a rule where larger tables are divided into smaller tables and they are linked using relationships.","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-normalization-in-sql\/","og_site_name":"Wikitechy","article_published_time":"2022-08-20T07:27:08+00:00","og_image":[{"url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/08\/database-normalization-.png","type":"","width":"","height":""}],"author":"webmaster","twitter_card":"summary_large_image","twitter_misc":{"Written by":"webmaster","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-normalization-in-sql\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-normalization-in-sql\/"},"author":{"name":"webmaster","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"headline":"What is Normalization in SQL ?","datePublished":"2022-08-20T07:27:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-normalization-in-sql\/"},"wordCount":127,"commentCount":0,"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-normalization-in-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/08\/database-normalization-.png","keywords":["normal forms in dbms","normalisation","normalisation in dbms","normalization","normalization example","normalization in dbms","normalization in sql","normalization sql","normalize database","types of normalization","what is database normalization","what is normalization and denormalization","what is normalization in computer","what is normalization in database","what is normalization in dbms","what is normalization in machine learning","what is normalization in python","what is normalization in sql","what is normalization in sql server","what is normalization in statistics","what is normalization of data","what is normalization of deviance"],"articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-normalization-in-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-normalization-in-sql\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-normalization-in-sql\/","name":"What is Normalization in SQL - DBMS Normalization - Wikitechy","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-normalization-in-sql\/#primaryimage"},"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-normalization-in-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/08\/database-normalization-.png","datePublished":"2022-08-20T07:27:08+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"description":"What is Normalization in SQL ? - It is a rule where larger tables are divided into smaller tables and they are linked using relationships.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-normalization-in-sql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-normalization-in-sql\/#primaryimage","url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/08\/database-normalization-.png","contentUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/08\/database-normalization-.png","width":831,"height":320},{"@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\/4827","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=4827"}],"version-history":[{"count":1,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4827\/revisions"}],"predecessor-version":[{"id":4830,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4827\/revisions\/4830"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=4827"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=4827"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=4827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}