{"id":447,"date":"2023-01-25T07:32:13","date_gmt":"2023-01-25T07:32:13","guid":{"rendered":"http:\/\/learnlearn.uk\/ibcs\/?page_id=447"},"modified":"2023-01-25T07:32:13","modified_gmt":"2023-01-25T07:32:13","slug":"database-normalisation-1nf-2nd-3nf","status":"publish","type":"page","link":"https:\/\/learnlearn.uk\/ibcs\/database-normalisation-1nf-2nd-3nf\/","title":{"rendered":"Database Normalisation &#8211; 1nf, 2nd &#038; 3nf"},"content":{"rendered":"<div class=\"responsive-tabs\">\n<h2 class=\"tabtitle\">Normalisation<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Database Normalisation<\/h3>\n<p>Normalisation is the process of removing redundancy within a database.<\/p>\n<p>Doing so:<\/p>\n<ul>\n<li>Makes accessing and storing data easier and more efficient<\/li>\n<li>Makes maintaining the database contents quicker and easier<\/li>\n<li>Reduces the chances of data errors or duplication.<\/li>\n<\/ul>\n<p>In order to a achieve this a set of rules were established to achieve efficiency &#8211; <strong>1st, 2nd and 3rd normal form<\/strong>. Each rule builds on the last rule, but think of it as a mental process that you go through to improve your database.<\/p>\n\n<\/div><h2 class=\"tabtitle\">Tutorial Video<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Tutorial Video<\/h3>\n<div class=\"nv-iframe-embed\">\n<div class=\"container-lazyload preview-lazyload container-youtube js-lazyload--not-loaded\"><a href=\"https:\/\/www.youtube.com\/watch?v=J-drts33N8g\" class=\"lazy-load-youtube preview-lazyload preview-youtube\" data-video-title=\"1st, 2nd and 3rd Normal Form (Database Normalisation)\" title=\"Play video &quot;1st, 2nd and 3rd Normal Form (Database Normalisation)&quot;\">https:\/\/www.youtube.com\/watch?v=J-drts33N8g<\/a><noscript>Video can&#8217;t be loaded because JavaScript is disabled: <a href=\"https:\/\/www.youtube.com\/watch?v=J-drts33N8g\" title=\"1st, 2nd and 3rd Normal Form (Database Normalisation)\">1st, 2nd and 3rd Normal Form (Database Normalisation) (https:\/\/www.youtube.com\/watch?v=J-drts33N8g)<\/a><\/noscript><\/div>\n<\/div>\n<p><a href=\"https:\/\/drive.google.com\/file\/d\/1ZhF0l8YkRJc09Job3bg4de0sOVIUzxCn\/view?usp=sharing\">Can&#8217;t access YouTube? Click Here for the Google Drive version.<\/a><\/p>\n\n<\/div><h2 class=\"tabtitle\">1NF<\/h2>\n<div class=\"tabcontent\">\n\n<h3>First Normal Form &#8220;Unique and atomic values&#8221;<\/h3>\n<ul>\n<li>Each Row in a database must be unique\n<ul>\n<li>Easily achieved through the use of a Primary Key<\/li>\n<\/ul>\n<\/li>\n<li>All cells must only contain one piece of data (no arrays stored in a cell)<\/li>\n<li>All column data must be of the same type<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n\n<\/div><h2 class=\"tabtitle\">2NF<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Second Normal Form &#8220;No Partial Dependencies&#8221;<\/h3>\n<ul>\n<li>This is only applicable if the\u00a0 table contains a composite key.<\/li>\n<li>The database must be in First Normal Form<\/li>\n<li>All columns within a table must depend on the whole key (No partial Dependency).<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n\n<\/div><h2 class=\"tabtitle\">3NF<\/h2>\n<div class=\"tabcontent\">\n\n<p><strong>Third Normal Form &#8220;No Transitive Dependencies&#8221;<\/strong><\/p>\n<ul>\n<li>The database must be in Second Normal Form<\/li>\n<li>All fields must only be determinable directly by the primary key (no transitive dependency)<\/li>\n<\/ul>\n<table class=\"wikitable\">\n<tbody>\n<tr>\n<th>Book<\/th>\n<th>Genre<\/th>\n<th>Author<\/th>\n<th>Author Nationality<\/th>\n<\/tr>\n<tr>\n<td><i><a title=\"Twenty Thousand Leagues Under the Sea\" href=\"https:\/\/en.wikipedia.org\/wiki\/Twenty_Thousand_Leagues_Under_the_Sea\">Twenty Thousand Leagues Under the Sea<\/a><\/i><\/td>\n<td><a class=\"mw-redirect\" title=\"Science Fiction\" href=\"https:\/\/en.wikipedia.org\/wiki\/Science_Fiction\">Science Fiction<\/a><\/td>\n<td><a title=\"Jules Verne\" href=\"https:\/\/en.wikipedia.org\/wiki\/Jules_Verne\">Jules Verne<\/a><\/td>\n<td><a title=\"French people\" href=\"https:\/\/en.wikipedia.org\/wiki\/French_people\">French<\/a><\/td>\n<\/tr>\n<tr>\n<td><i><a title=\"Journey to the Center of the Earth\" href=\"https:\/\/en.wikipedia.org\/wiki\/Journey_to_the_Center_of_the_Earth\">Journey to the Center of the Earth<\/a><\/i><\/td>\n<td><a class=\"mw-redirect\" title=\"Science Fiction\" href=\"https:\/\/en.wikipedia.org\/wiki\/Science_Fiction\">Science Fiction<\/a><\/td>\n<td><a title=\"Jules Verne\" href=\"https:\/\/en.wikipedia.org\/wiki\/Jules_Verne\">Jules Verne<\/a><\/td>\n<td>French<\/td>\n<\/tr>\n<tr>\n<td><i><a title=\"Leaves of Grass\" href=\"https:\/\/en.wikipedia.org\/wiki\/Leaves_of_Grass\">Leaves of Grass<\/a><\/i><\/td>\n<td><a title=\"Poetry\" href=\"https:\/\/en.wikipedia.org\/wiki\/Poetry\">Poetry<\/a><\/td>\n<td><a title=\"Walt Whitman\" href=\"https:\/\/en.wikipedia.org\/wiki\/Walt_Whitman\">Walt Whitman<\/a><\/td>\n<td><a title=\"United States\" href=\"https:\/\/en.wikipedia.org\/wiki\/United_States\">American<\/a><\/td>\n<\/tr>\n<tr>\n<td><i><a title=\"Anna Karenina\" href=\"https:\/\/en.wikipedia.org\/wiki\/Anna_Karenina\">Anna Karenina<\/a><\/i><\/td>\n<td><a class=\"mw-redirect\" title=\"Literary Fiction\" href=\"https:\/\/en.wikipedia.org\/wiki\/Literary_Fiction\">Literary Fiction<\/a><\/td>\n<td><a title=\"Leo Tolstoy\" href=\"https:\/\/en.wikipedia.org\/wiki\/Leo_Tolstoy\">Leo Tolstoy<\/a><\/td>\n<td><a title=\"Russians\" href=\"https:\/\/en.wikipedia.org\/wiki\/Russians\">Russian<\/a><\/td>\n<\/tr>\n<tr>\n<td><i><a title=\"A Confession\" href=\"https:\/\/en.wikipedia.org\/wiki\/A_Confession\">A Confession<\/a><\/i><\/td>\n<td><a class=\"new\" title=\"Religious Autobiography (page does not exist)\" href=\"https:\/\/en.wikipedia.org\/w\/index.php?title=Religious_Autobiography&amp;action=edit&amp;redlink=1\">Religious Autobiography<\/a><\/td>\n<td><a title=\"Leo Tolstoy\" href=\"https:\/\/en.wikipedia.org\/wiki\/Leo_Tolstoy\">Leo Tolstoy<\/a><\/td>\n<td>Russian<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>In the table above the Author Nationality is dependent on the Book only via the Author<\/p>\n<p>&#8220;The author of the book is French because the author of the book is Jules Verne&#8221;<\/p>\n<p>Author Nationality\u00a0 \u00a0&#8212;-&gt;\u00a0 Author\u00a0 &#8212;-&gt; Book<\/p>\n<p>&nbsp;<\/p>\n<p>A great video explaining the process &#8211;\u00a0<a href=\"https:\/\/www.youtube.com\/watch?v=UrYLYV7WSHM\">https:\/\/www.youtube.com\/watch?v=UrYLYV7WSHM<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n\n<\/div><h2 class=\"tabtitle\">Resources<\/h2>\n<div class=\"tabcontent\">\n\n<p><a href=\"https:\/\/docs.google.com\/presentation\/d\/1dJH-v1VfdUxdKsbs7KkFtBdePOpMGIalsu2GjrqOqsA\/edit?usp=sharing\">Teacher Presentation<\/a><\/p>\n<p><a href=\"https:\/\/www.cambridgeinternational.org\/Images\/524462-june-2017-question-paper-11.pdf\">Past paper questions 1 &#8211;\u00a0 (pages 2 &#8211; 3)<\/a><\/p>\n<p><a href=\"https:\/\/www.cambridgeinternational.org\/Images\/129845-2015-paper-1-specimen-paper.pdf\">Past paper questions 2- (pages 2 &#8211; 4)<\/a>\u00a0 &#8211; Includes questions on 1nf,3nf<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<\/div><\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database Normalisation Normalisation is the process of removing redundancy within a database. Doing so: Makes accessing and storing data easier and more efficient Makes maintaining the database contents quicker and easier Reduces the chances of data errors or duplication. In order to a achieve this a set of rules were established to achieve efficiency &#8211;&hellip;&nbsp;<a href=\"https:\/\/learnlearn.uk\/ibcs\/database-normalisation-1nf-2nd-3nf\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Database Normalisation &#8211; 1nf, 2nd &#038; 3nf<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":70,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Database Normalisation - 1nf, 2nd &amp; 3nf - IB Computer Science<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/learnlearn.uk\/ibcs\/database-normalisation-1nf-2nd-3nf\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Normalisation - 1nf, 2nd &amp; 3nf - IB Computer Science\" \/>\n<meta property=\"og:description\" content=\"Database Normalisation Normalisation is the process of removing redundancy within a database. Doing so: Makes accessing and storing data easier and more efficient Makes maintaining the database contents quicker and easier Reduces the chances of data errors or duplication. In order to a achieve this a set of rules were established to achieve efficiency &#8211;&hellip;&nbsp;Read More &raquo;Database Normalisation &#8211; 1nf, 2nd &#038; 3nf\" \/>\n<meta property=\"og:url\" content=\"https:\/\/learnlearn.uk\/ibcs\/database-normalisation-1nf-2nd-3nf\/\" \/>\n<meta property=\"og:site_name\" content=\"IB Computer Science\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/database-normalisation-1nf-2nd-3nf\/\",\"url\":\"https:\/\/learnlearn.uk\/ibcs\/database-normalisation-1nf-2nd-3nf\/\",\"name\":\"Database Normalisation - 1nf, 2nd & 3nf - IB Computer Science\",\"isPartOf\":{\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#website\"},\"datePublished\":\"2023-01-25T07:32:13+00:00\",\"dateModified\":\"2023-01-25T07:32:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/database-normalisation-1nf-2nd-3nf\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/learnlearn.uk\/ibcs\/database-normalisation-1nf-2nd-3nf\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/database-normalisation-1nf-2nd-3nf\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"IB Computer Science\",\"item\":\"https:\/\/learnlearn.uk\/ibcs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Normalisation &#8211; 1nf, 2nd &#038; 3nf\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#website\",\"url\":\"https:\/\/learnlearn.uk\/ibcs\/\",\"name\":\"IB Computer Science\",\"description\":\"- learnlearn..uk\",\"publisher\":{\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/learnlearn.uk\/ibcs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#organization\",\"name\":\"IB Computer Science\",\"url\":\"https:\/\/learnlearn.uk\/ibcs\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2022\/09\/LearnLearnLogowhite-300x41.png\",\"contentUrl\":\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2022\/09\/LearnLearnLogowhite-300x41.png\",\"width\":300,\"height\":41,\"caption\":\"IB Computer Science\"},\"image\":{\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database Normalisation - 1nf, 2nd & 3nf - IB Computer Science","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:\/\/learnlearn.uk\/ibcs\/database-normalisation-1nf-2nd-3nf\/","og_locale":"en_GB","og_type":"article","og_title":"Database Normalisation - 1nf, 2nd & 3nf - IB Computer Science","og_description":"Database Normalisation Normalisation is the process of removing redundancy within a database. Doing so: Makes accessing and storing data easier and more efficient Makes maintaining the database contents quicker and easier Reduces the chances of data errors or duplication. In order to a achieve this a set of rules were established to achieve efficiency &#8211;&hellip;&nbsp;Read More &raquo;Database Normalisation &#8211; 1nf, 2nd &#038; 3nf","og_url":"https:\/\/learnlearn.uk\/ibcs\/database-normalisation-1nf-2nd-3nf\/","og_site_name":"IB Computer Science","twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/learnlearn.uk\/ibcs\/database-normalisation-1nf-2nd-3nf\/","url":"https:\/\/learnlearn.uk\/ibcs\/database-normalisation-1nf-2nd-3nf\/","name":"Database Normalisation - 1nf, 2nd & 3nf - IB Computer Science","isPartOf":{"@id":"https:\/\/learnlearn.uk\/ibcs\/#website"},"datePublished":"2023-01-25T07:32:13+00:00","dateModified":"2023-01-25T07:32:13+00:00","breadcrumb":{"@id":"https:\/\/learnlearn.uk\/ibcs\/database-normalisation-1nf-2nd-3nf\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/learnlearn.uk\/ibcs\/database-normalisation-1nf-2nd-3nf\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/learnlearn.uk\/ibcs\/database-normalisation-1nf-2nd-3nf\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"IB Computer Science","item":"https:\/\/learnlearn.uk\/ibcs\/"},{"@type":"ListItem","position":2,"name":"Database Normalisation &#8211; 1nf, 2nd &#038; 3nf"}]},{"@type":"WebSite","@id":"https:\/\/learnlearn.uk\/ibcs\/#website","url":"https:\/\/learnlearn.uk\/ibcs\/","name":"IB Computer Science","description":"- learnlearn..uk","publisher":{"@id":"https:\/\/learnlearn.uk\/ibcs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/learnlearn.uk\/ibcs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/learnlearn.uk\/ibcs\/#organization","name":"IB Computer Science","url":"https:\/\/learnlearn.uk\/ibcs\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/learnlearn.uk\/ibcs\/#\/schema\/logo\/image\/","url":"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2022\/09\/LearnLearnLogowhite-300x41.png","contentUrl":"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2022\/09\/LearnLearnLogowhite-300x41.png","width":300,"height":41,"caption":"IB Computer Science"},"image":{"@id":"https:\/\/learnlearn.uk\/ibcs\/#\/schema\/logo\/image\/"}}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"learnlearnadmin","author_link":"https:\/\/learnlearn.uk\/ibcs\/author\/learnlearnadmin\/"},"rttpg_comment":0,"rttpg_category":null,"rttpg_excerpt":"Database Normalisation Normalisation is the process of removing redundancy within a database. Doing so: Makes accessing and storing data easier and more efficient Makes maintaining the database contents quicker and easier Reduces the chances of data errors or duplication. In order to a achieve this a set of rules were established to achieve efficiency &#8211;&hellip;&nbsp;Read&hellip;","_links":{"self":[{"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/pages\/447"}],"collection":[{"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/comments?post=447"}],"version-history":[{"count":1,"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/pages\/447\/revisions"}],"predecessor-version":[{"id":451,"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/pages\/447\/revisions\/451"}],"wp:attachment":[{"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/media?parent=447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}