{"id":300,"date":"2017-02-19T06:25:46","date_gmt":"2017-02-19T11:25:46","guid":{"rendered":"https:\/\/blog.khalilmamouny.com\/?p=300"},"modified":"2017-02-19T06:25:46","modified_gmt":"2017-02-19T11:25:46","slug":"bd-normalisation-formes-normales-fn","status":"publish","type":"post","link":"https:\/\/www.khalilmamouny.com\/index.php\/2017\/02\/19\/bd-normalisation-formes-normales-fn\/","title":{"rendered":"Base de donn\u00e9es &#8211; Normalisation et formes normales (FN)"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><style>\/*! elementor - v3.16.0 - 17-10-2023 *\/<br \/>\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">La normalisation est un processus qui consiste \u00e0 convertir les structures de donn\u00e9es complexes en structures de donn\u00e9es simples et stables.&nbsp;&nbsp;On utilise la normalisation pour :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>simplifier la structure de la base de donn\u00e9es et la rendre intuitive, consistante et coh\u00e9rente;<\/li>\n\n\n\n<li>faciliter la gestion de la structure et des donn\u00e9es de la base de donn\u00e9es;<\/li>\n\n\n\n<li>minimiser la redondance des donn\u00e9es;<\/li>\n\n\n\n<li>etc.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Le <b>processus de normalisation<\/b> est r\u00e9alis\u00e9 en \u00e9tapes. Chaque \u00e9tape consiste \u00e0 appliquer une <b>forme normale<\/b>.&nbsp;Il existe environ huit (8) formes normales mais seulement les trois (3) premi\u00e8res sont les plus utilis\u00e9es.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Dans ce tutoriel, je d\u00e9cris : a)&nbsp;ce que sont la normalisation et les trois premi\u00e8res formes normales; b)&nbsp;comment normaliser une base de donn\u00e9es relationnelle ; et, c)&nbsp;ce qu&rsquo;est la d\u00e9normalisation et quand l&rsquo;appliquer.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Tutoriel<\/h2>\n\n\n\n<p class=\"has-very-light-gray-to-cyan-bluish-gray-gradient-background has-background has-small-font-size wp-block-paragraph\"><iframe loading=\"lazy\" src=\"https:\/\/www.khalilmamouny.com\/wp-content\/uploads\/tutoriels\/bd-normalisation-et-formes-normales-fn\/index.html\" width=\"100%\" height=\"715px\"><\/iframe><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Pour un commentaire ou pour communiquer avec moi&#8230;<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">J&rsquo;esp\u00e8re que ce tutoriel vous a \u00e9t\u00e9 utile. N&rsquo;h\u00e9sitez pas \u00e0 me laisser votre commentaire en <u><strong><a href=\"https:\/\/www.khalilmamouny.com\/contact\/\" target=\"foobox\" rel=\"noopener noreferrer\">cliquant ici<\/a>.<\/strong><\/u><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.khalilmamouny.com\/wp-content\/uploads\/images\/khalilmamouny-at.png\" alt=\"Khalil Mamouny\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Dans ce tutoriel, je d\u00e9cris : a) ce que sont la normalisation et les trois premi\u00e8res formes normales; b) comment normaliser une base de donn\u00e9es relationnelle ; et, c) ce qu&rsquo;est la d\u00e9normalisation et quand l&rsquo;appliquer.<\/p>\n","protected":false},"author":1,"featured_media":8563,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,7],"tags":[14,21,26,27],"class_list":["post-300","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bases-de-donnees","category-modelisation","tag-base-de-donnees","tag-formes-normales","tag-modelisation","tag-normalisation","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"_links":{"self":[{"href":"https:\/\/www.khalilmamouny.com\/index.php\/wp-json\/wp\/v2\/posts\/300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.khalilmamouny.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.khalilmamouny.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.khalilmamouny.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.khalilmamouny.com\/index.php\/wp-json\/wp\/v2\/comments?post=300"}],"version-history":[{"count":0,"href":"https:\/\/www.khalilmamouny.com\/index.php\/wp-json\/wp\/v2\/posts\/300\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.khalilmamouny.com\/index.php\/wp-json\/wp\/v2\/media\/8563"}],"wp:attachment":[{"href":"https:\/\/www.khalilmamouny.com\/index.php\/wp-json\/wp\/v2\/media?parent=300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.khalilmamouny.com\/index.php\/wp-json\/wp\/v2\/categories?post=300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.khalilmamouny.com\/index.php\/wp-json\/wp\/v2\/tags?post=300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}