{"id":1040,"date":"2021-07-19T10:33:39","date_gmt":"2021-07-19T10:33:39","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=1040"},"modified":"2021-09-09T06:16:38","modified_gmt":"2021-09-09T06:16:38","slug":"what-is-normalization","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization\/","title":{"rendered":"What is Normalization ?"},"content":{"rendered":"
<\/div>\n
\n
\n
    \n
  • Normalization is the process of reorganizing data in a database. They have two basic requirements they are:\n
      \n
    • No redundancy of data.<\/li>\n
    • Logical as data dependencies.<\/li>\n<\/ul>\n<\/li>\n
    • To normalize a database, we divide the database into tables and establish relationships between the tables.<\/li>\n
    • Database normalization can essentially be defined as the practice of optimizing table structures.<\/li>\n
    • Optimization is accomplished as a result of a thorough investigation of the various pieces of data that will be stored within the database, in particular concentrating upon how this data is interrelated.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
      \n
      \"<\/div>\n<\/div>\n
      \n
      \n

      Types of Normalization<\/h2>\n<\/div>\n<\/div>\n
      \n
      \n
        \n
      • 1NF<\/li>\n
      • 2NF<\/li>\n
      • 3NF<\/li>\n
      • BCNF<\/li>\n
      • 4NF<\/li>\n
      • 5NF<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
        \n
        \n

        First Normal Form (1NF)<\/h2>\n<\/div>\n<\/div>\n
        \n
        \n
          \n
        • The First Normal Form should be following some rules in table,\n
            \n
          • It should only have single(atomic) valued attributes\/columns.<\/li>\n
          • Values stored in a column should be of the same domain<\/li>\n
          • All the columns in a table should have unique names.<\/li>\n
          • And the order in which data is stored, does not matter.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
            \n
            \n

            Second Normal Form (2NF)<\/h2>\n<\/div>\n<\/div>\n
            \n
            \n
              \n
            • For a table to be in the Second Normal Form,\n
                \n
              • It should be in the First Normal form.<\/li>\n
              • And, it should not have Partial Dependency.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
                \n
                \n

                Third Normal Form (3NF)<\/h2>\n<\/div>\n<\/div>\n
                \n
                \n
                  \n
                • A table is said to be in the Third Normal Form when,\n
                    \n
                  • It is in the Second Normal form.<\/li>\n
                  • And, it doesn\u2019t have Transitive Dependency.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
                    \n
                    \n

                    Boyce and Codd Normal Form (BCNF)<\/h2>\n<\/div>\n<\/div>\n
                    \n
                    \n
                      \n
                    • Boyce and Codd Normal Form is a higher version of the Third Normal form. This form deals with certain type of anomaly that is not handled by 3NF. A 3NF table which does not have multiple overlapping candidate keys is said to be in BCNF.<\/li>\n
                    • For a table to be in BCNF, following conditions must be satisfied:\n
                        \n
                      • R must be in 3rd Normal Form and, for each functional dependency ( X \u2192 Y ), X should be a super Key.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
                        \n
                        \n

                        Fourth Normal Form (4NF)<\/h2>\n<\/div>\n<\/div>\n
                        \n
                        \n
                          \n
                        • A table is said to be in the Fourth Normal Form when,\n
                            \n
                          • It is in the Boyce-Codd Normal Form.<\/li>\n
                          • And, it doesn\u2019t have Multi-Valued Dependency.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
                            \n
                            \n

                            Fifth Normal Form (5NF)<\/h2>\n<\/div>\n<\/div>\n
                            \n
                            \n
                              \n
                            • Fifth Normal Form (5NF), also known as project-join normal form (PJ\/NF) is a level of database normalization designed to reduce redundancy in relational databases recording multi-valued facts by isolating semantically related multiple relationships.<\/li>\n
                            • A relation R is in Fifth Normal Form (5NF) and only if the following conditions are satisfied simultaneously,\n
                                \n
                              • R is already in 4NF.<\/li>\n
                              • It cannot be further non-loss decomposed.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                                Answer : Normalization is the process of reorganizing data in a database…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7157],"tags":[7282,195,15897,360,7278,203,199,214,198,363,209,15937,7258,7257,7276,7268,205,222,196,212,213,286,710,207,366,7256,7266,7283,7259,7274,7264,7260,7261,7196,7277,7272,7271,7273,204,282,208,367,3715,206,7207,7275,7265,200,7267,7280,7279,7281,197,280,364,7263,7255,7270,7262,7269,285],"class_list":["post-1040","post","type-post","status-publish","format-standard","hentry","category-dbms","tag-2nf-normalization","tag-accenture-interview-questions-and-answers","tag-apostek-software-interview-questions-and-answers","tag-atos-interview-questions-and-answers","tag-bcnf-example","tag-capgemini-interview-questions-and-answers","tag-casting-networks-india-pvt-limited-interview-questions-and-answers","tag-cgi-group-inc-interview-questions-and-answers","tag-chetu-interview-questions-and-answers","tag-ciena-corporation-interview-questions-and-answers","tag-collabera-technologies-interview-questions-and-answers","tag-dark-horse-digital-interview-questions-and-answers","tag-data-normalization","tag-database-normalization","tag-database-normalization-examples","tag-define-normalization","tag-dell-international-services-india-pvt-ltd-interview-questions-and-answers","tag-flipkart-interview-questions-and-answers","tag-ibm-interview-questions-and-answers","tag-indecomm-global-services-interview-questions-and-answers","tag-infosys-technologies-interview-questions-and-answers","tag-lt-infotech-interview-questions-and-answers","tag-mavenir-interview-questions-and-answers","tag-mphasis-interview-questions-and-answers","tag-netapp-interview-questions-and-answers","tag-normalization","tag-normalization-definition","tag-normalization-definition-in-dbms","tag-normalization-example","tag-normalization-example-with-solution","tag-normalization-in-database","tag-normalization-in-database-with-example","tag-normalization-in-database-with-example-tables","tag-normalization-in-dbms","tag-normalization-in-dbms-with-examples","tag-normalization-statistics-example","tag-normalization-vs-standardization","tag-normalize-two-data-sets","tag-oracle-corporation-interview-questions-and-answers","tag-persistent-systems-interview-questions-and-answers","tag-prokarma-softech-pvt-ltd-interview-questions-and-answers","tag-rbs-india-development-centre-pvt-ltd-interview-questions-and-answers","tag-ruboid-technovision-pvt-ltd-interview-questions-and-answers","tag-sap-labs-india-pvt-ltd-interview-questions-and-answers","tag-shell-infotech-interview-questions-and-answers","tag-step-by-step-normalization-example","tag-table-normalization","tag-tech-mahindra-interview-questions-and-answers","tag-types-of-normalization","tag-types-of-normalization-in-database","tag-types-of-normalization-in-dbms","tag-types-of-normalization-with-examples","tag-unitedhealth-group-interview-questions-and-answers","tag-virtusa-consulting-services-pvt-ltd-interview-questions-and-answers","tag-wells-fargo-interview-questions-and-answers","tag-what-is-data-normalizationde","tag-what-is-normalization","tag-what-is-normalization-and-its-types","tag-what-is-normalization-in-dbms","tag-what-is-normalization-in-statistics","tag-xoriant-solutions-pvt-ltd-interview-questions-and-answers"],"yoast_head":"\nWhat is Normalization ? - DBMS Interview Questions - Wikitechy<\/title>\n<meta name=\"description\" content=\"What is Normalization ? - Normalization is the process of reorganizing data in a database.They have two basic requirements they are:No redundancy of data.\" \/>\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\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is Normalization ? - DBMS Interview Questions - Wikitechy\" \/>\n<meta property=\"og:description\" content=\"What is Normalization ? - Normalization is the process of reorganizing data in a database.They have two basic requirements they are:No redundancy of data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-19T10:33:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-09T06:16:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.wikitechy.com\/interview-questions\/dbms\/what-is-normalization.jpg\" \/>\n<meta name=\"author\" content=\"Editor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Editor\" \/>\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\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization\\\/\"},\"author\":{\"name\":\"Editor\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"headline\":\"What is Normalization ?\",\"datePublished\":\"2021-07-19T10:33:39+00:00\",\"dateModified\":\"2021-09-09T06:16:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization\\\/\"},\"wordCount\":393,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization.jpg\",\"keywords\":[\"2nf normalization\",\"Accenture interview questions and answers\",\"Apostek Software Interview Questions and Answers\",\"Atos interview questions and answers\",\"bcnf example\",\"Capgemini interview questions and answers\",\"CASTING NETWORKS INDIA PVT LIMITED interview questions and answers\",\"CGI Group Inc interview questions and answers\",\"Chetu interview questions and answers\",\"Ciena Corporation interview questions and answers\",\"Collabera Technologies interview questions and answers\",\"dark horse digital interview questions and answers\",\"data normalization\",\"database normalization\",\"database normalization examples\",\"define normalization\",\"Dell International Services India Pvt Ltd interview questions and answers\",\"Flipkart interview questions and answers\",\"IBM interview questions and answers\",\"Indecomm Global Services interview questions and answers\",\"Infosys Technologies interview questions and answers\",\"L&T Infotech interview questions and answers\",\"Mavenir interview questions and answers\",\"Mphasis interview questions and answers\",\"NetApp interview questions and answers\",\"normalization\",\"normalization definition\",\"normalization definition in dbms\",\"normalization example\",\"normalization example with solution\",\"normalization in database\",\"normalization in database with example\",\"normalization in database with example tables\",\"normalization in dbms\",\"normalization in dbms with examples\",\"normalization statistics example\",\"normalization vs standardization\",\"normalize two data sets\",\"Oracle Corporation interview questions and answers\",\"Persistent Systems interview questions and answers\",\"Prokarma Softech Pvt Ltd interview questions and answers\",\"RBS India Development Centre Pvt Ltd interview questions and answers\",\"Ruboid Technovision Pvt Ltd interview questions and answers\",\"SAP Labs India Pvt Ltd interview questions and answers\",\"Shell Infotech interview questions and answers\",\"step by step normalization example\",\"table normalization\",\"Tech Mahindra interview questions and answers\",\"types of normalization\",\"types of normalization in database\",\"types of normalization in dbms\",\"types of normalization with examples\",\"UnitedHealth Group interview questions and answers\",\"Virtusa Consulting Services Pvt Ltd interview questions and answers\",\"Wells Fargo interview questions and answers\",\"what is data normalizationde\",\"what is normalization\",\"what is normalization and its types\",\"what is normalization in dbms\",\"what is normalization in statistics\",\"Xoriant Solutions Pvt Ltd interview questions and answers\"],\"articleSection\":[\"DBMS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization\\\/\",\"name\":\"What is Normalization ? - DBMS Interview Questions - Wikitechy\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization.jpg\",\"datePublished\":\"2021-07-19T10:33:39+00:00\",\"dateModified\":\"2021-09-09T06:16:38+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"description\":\"What is Normalization ? - Normalization is the process of reorganizing data in a database.They have two basic requirements they are:No redundancy of data.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization.jpg\",\"contentUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-normalization.jpg\"},{\"@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\\\/4d5a581fb5470d1560324bddc5e8b757\",\"name\":\"Editor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"caption\":\"Editor\"},\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/author\\\/editor\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is Normalization ? - DBMS Interview Questions - Wikitechy","description":"What is Normalization ? - Normalization is the process of reorganizing data in a database.They have two basic requirements they are:No redundancy of data.","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\/","og_locale":"en_US","og_type":"article","og_title":"What is Normalization ? - DBMS Interview Questions - Wikitechy","og_description":"What is Normalization ? - Normalization is the process of reorganizing data in a database.They have two basic requirements they are:No redundancy of data.","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization\/","og_site_name":"Wikitechy","article_published_time":"2021-07-19T10:33:39+00:00","article_modified_time":"2021-09-09T06:16:38+00:00","og_image":[{"url":"https:\/\/cdn.wikitechy.com\/interview-questions\/dbms\/what-is-normalization.jpg","type":"","width":"","height":""}],"author":"Editor","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Editor","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization\/"},"author":{"name":"Editor","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"headline":"What is Normalization ?","datePublished":"2021-07-19T10:33:39+00:00","dateModified":"2021-09-09T06:16:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization\/"},"wordCount":393,"commentCount":0,"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/dbms\/what-is-normalization.jpg","keywords":["2nf normalization","Accenture interview questions and answers","Apostek Software Interview Questions and Answers","Atos interview questions and answers","bcnf example","Capgemini interview questions and answers","CASTING NETWORKS INDIA PVT LIMITED interview questions and answers","CGI Group Inc interview questions and answers","Chetu interview questions and answers","Ciena Corporation interview questions and answers","Collabera Technologies interview questions and answers","dark horse digital interview questions and answers","data normalization","database normalization","database normalization examples","define normalization","Dell International Services India Pvt Ltd interview questions and answers","Flipkart interview questions and answers","IBM interview questions and answers","Indecomm Global Services interview questions and answers","Infosys Technologies interview questions and answers","L&T Infotech interview questions and answers","Mavenir interview questions and answers","Mphasis interview questions and answers","NetApp interview questions and answers","normalization","normalization definition","normalization definition in dbms","normalization example","normalization example with solution","normalization in database","normalization in database with example","normalization in database with example tables","normalization in dbms","normalization in dbms with examples","normalization statistics example","normalization vs standardization","normalize two data sets","Oracle Corporation interview questions and answers","Persistent Systems interview questions and answers","Prokarma Softech Pvt Ltd interview questions and answers","RBS India Development Centre Pvt Ltd interview questions and answers","Ruboid Technovision Pvt Ltd interview questions and answers","SAP Labs India Pvt Ltd interview questions and answers","Shell Infotech interview questions and answers","step by step normalization example","table normalization","Tech Mahindra interview questions and answers","types of normalization","types of normalization in database","types of normalization in dbms","types of normalization with examples","UnitedHealth Group interview questions and answers","Virtusa Consulting Services Pvt Ltd interview questions and answers","Wells Fargo interview questions and answers","what is data normalizationde","what is normalization","what is normalization and its types","what is normalization in dbms","what is normalization in statistics","Xoriant Solutions Pvt Ltd interview questions and answers"],"articleSection":["DBMS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization\/","name":"What is Normalization ? - DBMS Interview Questions - Wikitechy","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization\/#primaryimage"},"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/dbms\/what-is-normalization.jpg","datePublished":"2021-07-19T10:33:39+00:00","dateModified":"2021-09-09T06:16:38+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"description":"What is Normalization ? - Normalization is the process of reorganizing data in a database.They have two basic requirements they are:No redundancy of data.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-normalization\/#primaryimage","url":"https:\/\/cdn.wikitechy.com\/interview-questions\/dbms\/what-is-normalization.jpg","contentUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/dbms\/what-is-normalization.jpg"},{"@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\/4d5a581fb5470d1560324bddc5e8b757","name":"Editor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","caption":"Editor"},"url":"https:\/\/www.wikitechy.com\/interview-questions\/author\/editor\/"}]}},"_links":{"self":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/1040","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/comments?post=1040"}],"version-history":[{"count":3,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/1040\/revisions"}],"predecessor-version":[{"id":3112,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/1040\/revisions\/3112"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=1040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=1040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=1040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}