https://projects.info.unamur.be/~dbm/mediawiki/index.php?action=history&feed=atom&title=DUNOD2022_Cours_introductif DUNOD2022 Cours introductif - Historique des versions 2026-04-15T08:16:51Z Historique pour cette page sur le wiki MediaWiki 1.18.1 https://projects.info.unamur.be/~dbm/mediawiki/index.php?title=DUNOD2022_Cours_introductif&diff=2075&oldid=prev Dbm le 17 décembre 2022 à 17:37 2022-12-17T17:37:25Z <p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Version précédente</td> <td colspan='2' style="background-color: white; color:black;">Version du 17 décembre 2022 à 17:37</td> </tr><tr><td colspan="2" class="diff-lineno">Ligne 7 :</td> <td colspan="2" class="diff-lineno">Ligne 7 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>Pour rappel, les diaporamas sont disponibles [https://bit.ly/3NHct7J '''ici'''] et les annexes [https://bit.ly/3afbuxR '''ici'''].</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>Pour rappel, les diaporamas sont disponibles [https://bit.ly/3NHct7J '''ici'''] et les annexes [https://bit.ly/3afbuxR '''ici'''].</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>[<del class="diffchange diffchange-inline">[DUNOD2022|</del>&lt;Retour à la page de l'ouvrage&gt;<del class="diffchange diffchange-inline">]</del>]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>[<ins class="diffchange diffchange-inline">https://bit.ly/3a5jYro </ins>&lt;Retour à la page de l'ouvrage&gt;]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>{| border=&quot;1&quot;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>{| border=&quot;1&quot;</div></td></tr> </table> Dbm https://projects.info.unamur.be/~dbm/mediawiki/index.php?title=DUNOD2022_Cours_introductif&diff=2039&oldid=prev Dbm le 5 juillet 2022 à 14:05 2022-07-05T14:05:11Z <p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Version précédente</td> <td colspan='2' style="background-color: white; color:black;">Version du 5 juillet 2022 à 14:05</td> </tr><tr><td colspan="2" class="diff-lineno">Ligne 3 :</td> <td colspan="2" class="diff-lineno">Ligne 3 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>:Ce premier parcours est proposé au lecteur débutant, désireux d'aborder l'essentiel des concepts des bases de données, du langage SQL et des méthodes de construction d'une base de données sans toutefois rentrer dans trop de détails. Au terme de ce parcours, le lecteur sera à même de comprendre les enjeux, les problèmes et les solutions propres au domaine des bases de données. Sur le plan pratique, il sera capable d'interroger une base de données de complexité moyenne à l'aide du langage SQL. Il aura enfin suffisamment d'assurance pour construire de manière systématique et raisonnée de petites bases de données de faible complexité. &#160;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>:Ce premier parcours est proposé au lecteur débutant, désireux d'aborder l'essentiel des concepts des bases de données, du langage SQL et des méthodes de construction d'une base de données sans toutefois rentrer dans trop de détails. Au terme de ce parcours, le lecteur sera à même de comprendre les enjeux, les problèmes et les solutions propres au domaine des bases de données. Sur le plan pratique, il sera capable d'interroger une base de données de complexité moyenne à l'aide du langage SQL. Il aura enfin suffisamment d'assurance pour construire de manière systématique et raisonnée de petites bases de données de faible complexité. &#160;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>:Les documents de support du cours se présentent sous la forme de diaporamas en Powerpoint. Les annexes contiennent des exercices et leurs solutions ainsi que des compléments d'information.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>:Les documents de support du cours se présentent sous la forme de diaporamas en Powerpoint. Les annexes contiennent des exercices et leurs solutions ainsi que des compléments d'information<ins class="diffchange diffchange-inline">. Le code SQL de chaque chapitre, tel qu'il était disponible dans les éditions précédente est désormais intégré au l'environnement SQLfast sous la forme d'une bibliothèque de code</ins>.</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>Pour rappel, les diaporamas sont disponibles [https://bit.ly/3NHct7J '''ici'''] et les annexes [https://bit.ly/3afbuxR '''ici'''].</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>Pour rappel, les diaporamas sont disponibles [https://bit.ly/3NHct7J '''ici'''] et les annexes [https://bit.ly/3afbuxR '''ici'''].</div></td></tr> <tr><td colspan="2" class="diff-lineno">Ligne 21 :</td> <td colspan="2" class="diff-lineno">Ligne 21 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Concepts des bases de données</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Concepts des bases de données</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| '''Chapitre 2'''&lt;br&gt;Annexe A02<del class="diffchange diffchange-inline">&lt;br&gt;Compléments&lt;br&gt;&lt;br&gt;</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| '''Chapitre 2'''&lt;br&gt;Annexe A02</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| BD-2022-02-Concepts-des-bases-de-donnees.ppt&lt;br&gt;A02-Concepts-des-bases-de-donnees.pdf<del class="diffchange diffchange-inline">&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/Schema-CLICOM.pdf Schema-CLICOM.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/Chapitre-02-Scripts-SQLfast.zip Chap-02-Scripts.zip]</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| BD-2022-02-Concepts-des-bases-de-donnees.ppt&lt;br&gt;A02-Concepts-des-bases-de-donnees.pdf</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| colspan=&quot;3&quot; | &lt;center&gt;'''UTILISATION DES BASES DE DONNEES'''&lt;/center&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| colspan=&quot;3&quot; | &lt;center&gt;'''UTILISATION DES BASES DE DONNEES'''&lt;/center&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno">Ligne 31 :</td> <td colspan="2" class="diff-lineno">Ligne 31 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DDL</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DDL</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| '''Chapitre 6'''&lt;br&gt;Annexe A06<del class="diffchange diffchange-inline">&lt;br&gt;Compléments&lt;br&gt;&lt;br&gt;</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| '''Chapitre 6'''&lt;br&gt;Annexe A06</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| BD-2022-06-SQL-DDL.ppt&lt;br&gt;A06-Le-langage-SQL-DDL.pdf<del class="diffchange diffchange-inline">&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/SQL2-Syntax.pdf SQL2-Syntax.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/Chapitre-06-Scripts-SQLfast.zip Chap-06-Scripts.zip]</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| BD-2022-06-SQL-DDL.ppt&lt;br&gt;A06-Le-langage-SQL-DDL.pdf</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DML (1)</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DML (1)</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| '''Chapitre 7'''&lt;br&gt;Annexe A07<del class="diffchange diffchange-inline">&lt;br&gt;Compléments</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| '''Chapitre 7'''&lt;br&gt;Annexe A07</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| BD-2022-07-SQL-DML-(1).ppt&lt;br&gt;A07-Le-langage-SQL-DML(1).pdf<del class="diffchange diffchange-inline">&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-07/Chapitre-07-Scripts-SQLfast.zip Chap-07-Scripts.zip]</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| BD-2022-07-SQL-DML-(1).ppt&lt;br&gt;A07-Le-langage-SQL-DML(1).pdf</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DML (2)</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DML (2)</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| '''Chapitre 8'''&lt;br&gt;Annexe A08<del class="diffchange diffchange-inline">&lt;br&gt;Compléments</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| '''Chapitre 8'''&lt;br&gt;Annexe A08</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>|BD-2022-2022-08-SQL-DML-(2).ppt&lt;br&gt;A08-Le-langage-SQL-DML(2).pdf<del class="diffchange diffchange-inline">&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-08/Chapitre-08-Scripts-SQLfast.zip Chap-08-Scripts.zip]</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>|BD-2022-2022-08-SQL-DML-(2).ppt&lt;br&gt;A08-Le-langage-SQL-DML(2).pdf</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| colspan=&quot;3&quot; | &lt;center&gt;'''DEVELOPPEMENT D'UNE BASE DE DONNEES'''&lt;/center&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| colspan=&quot;3&quot; | &lt;center&gt;'''DEVELOPPEMENT D'UNE BASE DE DONNEES'''&lt;/center&gt;</div></td></tr> </table> Dbm https://projects.info.unamur.be/~dbm/mediawiki/index.php?title=DUNOD2022_Cours_introductif&diff=2030&oldid=prev Dbm le 4 juillet 2022 à 17:33 2022-07-04T17:33:24Z <p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Version précédente</td> <td colspan='2' style="background-color: white; color:black;">Version du 4 juillet 2022 à 17:33</td> </tr><tr><td colspan="2" class="diff-lineno">Ligne 4 :</td> <td colspan="2" class="diff-lineno">Ligne 4 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>:Les documents de support du cours se présentent sous la forme de diaporamas en Powerpoint. Les annexes contiennent des exercices et leurs solutions ainsi que des compléments d'information.</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>:Les documents de support du cours se présentent sous la forme de diaporamas en Powerpoint. Les annexes contiennent des exercices et leurs solutions ainsi que des compléments d'information.</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">Pour rappel, les diaporamas sont disponibles [https://bit.ly/3NHct7J '''ici'''] et les annexes [https://bit.ly/3afbuxR '''ici'''].</ins></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>[[DUNOD2022|&lt;Retour à la page de l'ouvrage&gt;]]</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>[[DUNOD2022|&lt;Retour à la page de l'ouvrage&gt;]]</div></td></tr> </table> Dbm https://projects.info.unamur.be/~dbm/mediawiki/index.php?title=DUNOD2022_Cours_introductif&diff=2027&oldid=prev Dbm le 4 juillet 2022 à 17:04 2022-07-04T17:04:50Z <p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Version précédente</td> <td colspan='2' style="background-color: white; color:black;">Version du 4 juillet 2022 à 17:04</td> </tr><tr><td colspan="2" class="diff-lineno">Ligne 15 :</td> <td colspan="2" class="diff-lineno">Ligne 15 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Motivation et introduction</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Motivation et introduction</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| Chapitre 1</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">'''</ins>Chapitre 1<ins class="diffchange diffchange-inline">'''</ins></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| BD-2022-01-Motivation-et-introduction.ppt</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| BD-2022-01-Motivation-et-introduction.ppt</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Concepts des bases de données</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Concepts des bases de données</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| Chapitre 2&lt;br&gt;Annexe A02&lt;br&gt;Compléments&lt;br&gt;&lt;br&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">'''</ins>Chapitre 2<ins class="diffchange diffchange-inline">'''</ins>&lt;br&gt;Annexe A02&lt;br&gt;Compléments&lt;br&gt;&lt;br&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| BD-2022-02-Concepts-des-bases-de-donnees.ppt&lt;br&gt;A02-Concepts-des-bases-de-donnees.pdf&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/Schema-CLICOM.pdf Schema-CLICOM.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/Chapitre-02-Scripts-SQLfast.zip Chap-02-Scripts.zip]</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| BD-2022-02-Concepts-des-bases-de-donnees.ppt&lt;br&gt;A02-Concepts-des-bases-de-donnees.pdf&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/Schema-CLICOM.pdf Schema-CLICOM.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/Chapitre-02-Scripts-SQLfast.zip Chap-02-Scripts.zip]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td colspan="2" class="diff-lineno">Ligne 29 :</td> <td colspan="2" class="diff-lineno">Ligne 29 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DDL</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DDL</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| Chapitre 6&lt;br&gt;Annexe A06&lt;br&gt;Compléments&lt;br&gt;&lt;br&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">'''</ins>Chapitre 6<ins class="diffchange diffchange-inline">'''</ins>&lt;br&gt;Annexe A06&lt;br&gt;Compléments&lt;br&gt;&lt;br&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| BD-2022-06-SQL-DDL.ppt&lt;br&gt;A06-Le-langage-SQL-DDL.pdf&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/SQL2-Syntax.pdf SQL2-Syntax.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/Chapitre-06-Scripts-SQLfast.zip Chap-06-Scripts.zip]</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| BD-2022-06-SQL-DDL.ppt&lt;br&gt;A06-Le-langage-SQL-DDL.pdf&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/SQL2-Syntax.pdf SQL2-Syntax.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/Chapitre-06-Scripts-SQLfast.zip Chap-06-Scripts.zip]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DML (1)</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DML (1)</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| Chapitre 7&lt;br&gt;Annexe A07&lt;br&gt;Compléments</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">'''</ins>Chapitre 7<ins class="diffchange diffchange-inline">'''</ins>&lt;br&gt;Annexe A07&lt;br&gt;Compléments</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| BD-2022-07-SQL-DML-(1).ppt&lt;br&gt;A07-Le-langage-SQL-DML(1).pdf&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-07/Chapitre-07-Scripts-SQLfast.zip Chap-07-Scripts.zip]</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| BD-2022-07-SQL-DML-(1).ppt&lt;br&gt;A07-Le-langage-SQL-DML(1).pdf&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-07/Chapitre-07-Scripts-SQLfast.zip Chap-07-Scripts.zip]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DML (2)</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DML (2)</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| Chapitre 8&lt;br&gt;Annexe A08&lt;br&gt;Compléments</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">'''</ins>Chapitre 8<ins class="diffchange diffchange-inline">'''</ins>&lt;br&gt;Annexe A08&lt;br&gt;Compléments</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|BD-2022-2022-08-SQL-DML-(2).ppt&lt;br&gt;A08-Le-langage-SQL-DML(2).pdf&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-08/Chapitre-08-Scripts-SQLfast.zip Chap-08-Scripts.zip]</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|BD-2022-2022-08-SQL-DML-(2).ppt&lt;br&gt;A08-Le-langage-SQL-DML(2).pdf&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-08/Chapitre-08-Scripts-SQLfast.zip Chap-08-Scripts.zip]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td colspan="2" class="diff-lineno">Ligne 47 :</td> <td colspan="2" class="diff-lineno">Ligne 47 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Construction d'une BD</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Construction d'une BD</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| Chapitre 12</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">'''</ins>Chapitre 12<ins class="diffchange diffchange-inline">'''</ins></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chap-12-Construction-d-une-BD.ppt</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chap-12-Construction-d-une-BD.ppt</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le modèle Entité-association de base</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le modèle Entité-association de base</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| Chapitre 13&lt;br&gt;Annexe A13</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">'''</ins>Chapitre 13<ins class="diffchange diffchange-inline">'''</ins>&lt;br&gt;Annexe A13</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| BD-2022-13-Modele-EA-de-base.ppt&lt;br&gt;A13-Modele-EA-de-base.pdf</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| BD-2022-13-Modele-EA-de-base.ppt&lt;br&gt;A13-Modele-EA-de-base.pdf</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Elaboration d'un schéma conceptuel</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Elaboration d'un schéma conceptuel</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| Chapitre 14&lt;br&gt;Annexe A14</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">'''</ins>Chapitre 14<ins class="diffchange diffchange-inline">'''</ins>&lt;br&gt;Annexe A14</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| BD-2022-2022-14-Elaboration-d-un-schema-conceptuel.ppt&lt;br&gt;A14-Elaboration-d-un-schema-conceptuel.pdf</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| BD-2022-2022-14-Elaboration-d-un-schema-conceptuel.ppt&lt;br&gt;A14-Elaboration-d-un-schema-conceptuel.pdf</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Production du schéma de la BD</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Production du schéma de la BD</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| Chapitre 15&lt;br&gt;Annexe A15</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">'''</ins>Chapitre 15<ins class="diffchange diffchange-inline">'''</ins>&lt;br&gt;Annexe A15</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| BD-2022-2022-15-Production-du-schema-de-la-BD.ppt&lt;br&gt;A15-Production-du-schema-de-la-BD.pdf</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| BD-2022-2022-15-Production-du-schema-de-la-BD.ppt&lt;br&gt;A15-Production-du-schema-de-la-BD.pdf</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Etudes de cas</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Etudes de cas</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| Chapitre 24&lt;br&gt;Annexe A24</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">'''</ins>Chapitre 24<ins class="diffchange diffchange-inline">'''</ins>&lt;br&gt;Annexe A24</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| &lt;br&gt;A24-Etudes-de-cas.pdf</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| &lt;br&gt;A24-Etudes-de-cas.pdf</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> </table> Dbm https://projects.info.unamur.be/~dbm/mediawiki/index.php?title=DUNOD2022_Cours_introductif&diff=2026&oldid=prev Dbm le 4 juillet 2022 à 17:02 2022-07-04T17:02:19Z <p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Version précédente</td> <td colspan='2' style="background-color: white; color:black;">Version du 4 juillet 2022 à 17:02</td> </tr><tr><td colspan="2" class="diff-lineno">Ligne 20 :</td> <td colspan="2" class="diff-lineno">Ligne 20 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Concepts des bases de données</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Concepts des bases de données</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 2&lt;br&gt;Annexe A02&lt;br&gt;Compléments&lt;br&gt;&lt;br&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 2&lt;br&gt;Annexe A02&lt;br&gt;Compléments&lt;br&gt;&lt;br&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| BD-2022-02-Concepts-des-bases-de-donnees.ppt&lt;br&gt;<del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/JLH-A02-Concepts-des-bases-de-donnees.pdf </del>A02-Concepts-des-bases-de-donnees.pdf<del class="diffchange diffchange-inline">]</del>&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/Schema-CLICOM.pdf Schema-CLICOM.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/Chapitre-02-Scripts-SQLfast.zip Chap-02-Scripts.zip]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| BD-2022-02-Concepts-des-bases-de-donnees.ppt&lt;br&gt;A02-Concepts-des-bases-de-donnees.pdf&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/Schema-CLICOM.pdf Schema-CLICOM.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/Chapitre-02-Scripts-SQLfast.zip Chap-02-Scripts.zip]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| colspan=&quot;3&quot; | &lt;center&gt;'''UTILISATION DES BASES DE DONNEES'''&lt;/center&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| colspan=&quot;3&quot; | &lt;center&gt;'''UTILISATION DES BASES DE DONNEES'''&lt;/center&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno">Ligne 30 :</td> <td colspan="2" class="diff-lineno">Ligne 30 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DDL</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DDL</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 6&lt;br&gt;Annexe A06&lt;br&gt;Compléments&lt;br&gt;&lt;br&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 6&lt;br&gt;Annexe A06&lt;br&gt;Compléments&lt;br&gt;&lt;br&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| BD-2022-06-SQL-DDL.ppt&lt;br&gt;<del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/JLH-A06-Le-langage-SQL-DDL.pdf </del>A06-Le-langage-SQL-DDL.pdf<del class="diffchange diffchange-inline">]</del>&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/SQL2-Syntax.pdf SQL2-Syntax.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/Chapitre-06-Scripts-SQLfast.zip Chap-06-Scripts.zip]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| BD-2022-06-SQL-DDL.ppt&lt;br&gt;A06-Le-langage-SQL-DDL.pdf&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/SQL2-Syntax.pdf SQL2-Syntax.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/Chapitre-06-Scripts-SQLfast.zip Chap-06-Scripts.zip]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DML (1)</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DML (1)</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 7&lt;br&gt;Annexe A07&lt;br&gt;Compléments</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 7&lt;br&gt;Annexe A07&lt;br&gt;Compléments</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| BD-2022-07-SQL-DML-(1).ppt&lt;br&gt;<del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-07/JLH-A07-Le-langage-SQL-DML(1).pdf </del>A07-Le-langage-SQL-DML(1).pdf<del class="diffchange diffchange-inline">]</del>&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-07/Chapitre-07-Scripts-SQLfast.zip Chap-07-Scripts.zip]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| BD-2022-07-SQL-DML-(1).ppt&lt;br&gt;A07-Le-langage-SQL-DML(1).pdf&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-07/Chapitre-07-Scripts-SQLfast.zip Chap-07-Scripts.zip]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DML (2)</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DML (2)</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 8&lt;br&gt;Annexe A08&lt;br&gt;Compléments</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 8&lt;br&gt;Annexe A08&lt;br&gt;Compléments</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>|BD-2022-2022-08-SQL-DML-(2).ppt&lt;br&gt;<del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-08/JLH-A08-Le-langage-SQL-DML(2).pdf </del>A08-Le-langage-SQL-DML(2).pdf<del class="diffchange diffchange-inline">]</del>&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-08/Chapitre-08-Scripts-SQLfast.zip Chap-08-Scripts.zip]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>|BD-2022-2022-08-SQL-DML-(2).ppt&lt;br&gt;A08-Le-langage-SQL-DML(2).pdf&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-08/Chapitre-08-Scripts-SQLfast.zip Chap-08-Scripts.zip]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| colspan=&quot;3&quot; | &lt;center&gt;'''DEVELOPPEMENT D'UNE BASE DE DONNEES'''&lt;/center&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| colspan=&quot;3&quot; | &lt;center&gt;'''DEVELOPPEMENT D'UNE BASE DE DONNEES'''&lt;/center&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno">Ligne 52 :</td> <td colspan="2" class="diff-lineno">Ligne 52 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le modèle Entité-association de base</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le modèle Entité-association de base</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 13&lt;br&gt;Annexe A13</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 13&lt;br&gt;Annexe A13</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| BD-2022-13-Modele-EA-de-base.ppt&lt;br&gt;<del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-12/JLH-A12-Modele-EA-de-base.pdf A12</del>-Modele-EA-de-base.pdf<del class="diffchange diffchange-inline">]</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| BD-2022-13-Modele-EA-de-base.ppt&lt;br&gt;<ins class="diffchange diffchange-inline">A13</ins>-Modele-EA-de-base.pdf</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Elaboration d'un schéma conceptuel</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Elaboration d'un schéma conceptuel</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 14&lt;br&gt;Annexe A14</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 14&lt;br&gt;Annexe A14</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| BD-2022-2022-14-Elaboration-d-un-schema-conceptuel.ppt&lt;br&gt;<del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-13/JLH-A13-Elaboration-d-un-schema-conceptuel.pdf A13</del>-Elaboration-d-un-schema-conceptuel.pdf<del class="diffchange diffchange-inline">]</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| BD-2022-2022-14-Elaboration-d-un-schema-conceptuel.ppt&lt;br&gt;<ins class="diffchange diffchange-inline">A14</ins>-Elaboration-d-un-schema-conceptuel.pdf</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Production du schéma de la BD</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Production du schéma de la BD</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 15&lt;br&gt;Annexe A15</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 15&lt;br&gt;Annexe A15</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| BD-2022-2022-15-Production-du-schema-de-la-BD.ppt&lt;br&gt;<del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-14/JLH-A14-Production-du-schema-de-la-BD.pdf A14</del>-Production-du-schema-de-la-BD.pdf<del class="diffchange diffchange-inline">]</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| BD-2022-2022-15-Production-du-schema-de-la-BD.ppt&lt;br&gt;<ins class="diffchange diffchange-inline">A15</ins>-Production-du-schema-de-la-BD.pdf</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Etudes de cas</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Etudes de cas</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 24&lt;br&gt;Annexe A24</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 24&lt;br&gt;Annexe A24</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| &lt;br&gt;<del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-23/JLH-A23-Etudes-de-cas.pdf A23</del>-Etudes-de-cas.pdf<del class="diffchange diffchange-inline">]</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| &lt;br&gt;<ins class="diffchange diffchange-inline">A24</ins>-Etudes-de-cas.pdf</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| colspan=&quot;3&quot; | &lt;center&gt;'''COMPLEMENTS FACULTATIFS'''&lt;/center&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| colspan=&quot;3&quot; | &lt;center&gt;'''COMPLEMENTS FACULTATIFS'''&lt;/center&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno">Ligne 78 :</td> <td colspan="2" class="diff-lineno">Ligne 78 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Conventions graphiques</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Conventions graphiques</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Annexe A30</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Annexe A30</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| A30-Graphique-ER.pdf<del class="diffchange diffchange-inline">]</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| A30-Graphique-ER.pdf</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|}</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|}</div></td></tr> </table> Dbm https://projects.info.unamur.be/~dbm/mediawiki/index.php?title=DUNOD2022_Cours_introductif&diff=2025&oldid=prev Dbm le 4 juillet 2022 à 16:55 2022-07-04T16:55:18Z <p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Version précédente</td> <td colspan='2' style="background-color: white; color:black;">Version du 4 juillet 2022 à 16:55</td> </tr><tr><td colspan="2" class="diff-lineno">Ligne 16 :</td> <td colspan="2" class="diff-lineno">Ligne 16 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Motivation et introduction</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Motivation et introduction</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 1</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 1</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| <del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod</del>-<del class="diffchange diffchange-inline">2018/Chapitres/Chapitre-01/JLH-01-Motivation-et-introduction.ppt Chap</del>-01-Motivation-et-introduction.ppt<del class="diffchange diffchange-inline">]</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">BD</ins>-<ins class="diffchange diffchange-inline">2022</ins>-01-Motivation-et-introduction.ppt</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Concepts des bases de données</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Concepts des bases de données</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 2&lt;br&gt;Annexe A02&lt;br&gt;Compléments&lt;br&gt;&lt;br&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 2&lt;br&gt;Annexe A02&lt;br&gt;Compléments&lt;br&gt;&lt;br&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| <del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod</del>-<del class="diffchange diffchange-inline">2018/Chapitres/Chapitre-02/JLH-02-Concepts-des-bases-de-donnees.ppt Chap</del>-02-Concepts-des-bases-de-donnees.ppt<del class="diffchange diffchange-inline">]</del>&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/JLH-A02-Concepts-des-bases-de-donnees.pdf A02-Concepts-des-bases-de-donnees.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/Schema-CLICOM.pdf Schema-CLICOM.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/Chapitre-02-Scripts-SQLfast.zip Chap-02-Scripts.zip]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">BD</ins>-<ins class="diffchange diffchange-inline">2022</ins>-02-Concepts-des-bases-de-donnees.ppt&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/JLH-A02-Concepts-des-bases-de-donnees.pdf A02-Concepts-des-bases-de-donnees.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/Schema-CLICOM.pdf Schema-CLICOM.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/Chapitre-02-Scripts-SQLfast.zip Chap-02-Scripts.zip]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| colspan=&quot;3&quot; | &lt;center&gt;'''UTILISATION DES BASES DE DONNEES'''&lt;/center&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| colspan=&quot;3&quot; | &lt;center&gt;'''UTILISATION DES BASES DE DONNEES'''&lt;/center&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno">Ligne 30 :</td> <td colspan="2" class="diff-lineno">Ligne 30 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DDL</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DDL</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 6&lt;br&gt;Annexe A06&lt;br&gt;Compléments&lt;br&gt;&lt;br&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 6&lt;br&gt;Annexe A06&lt;br&gt;Compléments&lt;br&gt;&lt;br&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| <del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod</del>-<del class="diffchange diffchange-inline">2018/Chapitres/Chapitre-06/JLH-06-SQL-DDL.ppt Chap</del>-06-SQL-DDL.ppt<del class="diffchange diffchange-inline">]</del>&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/JLH-A06-Le-langage-SQL-DDL.pdf A06-Le-langage-SQL-DDL.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/SQL2-Syntax.pdf SQL2-Syntax.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/Chapitre-06-Scripts-SQLfast.zip Chap-06-Scripts.zip]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">BD</ins>-<ins class="diffchange diffchange-inline">2022</ins>-06-SQL-DDL.ppt&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/JLH-A06-Le-langage-SQL-DDL.pdf A06-Le-langage-SQL-DDL.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/SQL2-Syntax.pdf SQL2-Syntax.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/Chapitre-06-Scripts-SQLfast.zip Chap-06-Scripts.zip]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DML (1)</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DML (1)</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 7&lt;br&gt;Annexe A07&lt;br&gt;Compléments</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 7&lt;br&gt;Annexe A07&lt;br&gt;Compléments</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| <del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod</del>-<del class="diffchange diffchange-inline">2018/Chapitres/Chapitre-07/JLH-07-SQL-DML-(1).ppt Chap</del>-07-SQL-DML-(1).ppt<del class="diffchange diffchange-inline">]</del>&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-07/JLH-A07-Le-langage-SQL-DML(1).pdf A07-Le-langage-SQL-DML(1).pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-07/Chapitre-07-Scripts-SQLfast.zip Chap-07-Scripts.zip]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">BD</ins>-<ins class="diffchange diffchange-inline">2022</ins>-07-SQL-DML-(1).ppt&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-07/JLH-A07-Le-langage-SQL-DML(1).pdf A07-Le-langage-SQL-DML(1).pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-07/Chapitre-07-Scripts-SQLfast.zip Chap-07-Scripts.zip]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DML (2)</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le langage SQL DML (2)</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 8&lt;br&gt;Annexe A08&lt;br&gt;Compléments</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Chapitre 8&lt;br&gt;Annexe A08&lt;br&gt;Compléments</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| <del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod</del>-<del class="diffchange diffchange-inline">2018/Chapitres/Chapitre</del>-<del class="diffchange diffchange-inline">08/JLH-08-SQL-DML-(2).ppt Chap</del>-08-SQL-DML-(2).ppt<del class="diffchange diffchange-inline">]</del>&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-08/JLH-A08-Le-langage-SQL-DML(2).pdf A08-Le-langage-SQL-DML(2).pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-08/Chapitre-08-Scripts-SQLfast.zip Chap-08-Scripts.zip]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>|<ins class="diffchange diffchange-inline">BD</ins>-<ins class="diffchange diffchange-inline">2022</ins>-<ins class="diffchange diffchange-inline">2022</ins>-08-SQL-DML-(2).ppt&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-08/JLH-A08-Le-langage-SQL-DML(2).pdf A08-Le-langage-SQL-DML(2).pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-08/Chapitre-08-Scripts-SQLfast.zip Chap-08-Scripts.zip]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| colspan=&quot;3&quot; | &lt;center&gt;'''DEVELOPPEMENT D'UNE BASE DE DONNEES'''&lt;/center&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| colspan=&quot;3&quot; | &lt;center&gt;'''DEVELOPPEMENT D'UNE BASE DE DONNEES'''&lt;/center&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno">Ligne 47 :</td> <td colspan="2" class="diff-lineno">Ligne 47 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Construction d'une BD</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Construction d'une BD</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| Chapitre <del class="diffchange diffchange-inline">11</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| Chapitre <ins class="diffchange diffchange-inline">12</ins></div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| <del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-11/JLH-11-Construction-d-une-BD.ppt </del>Chap-<del class="diffchange diffchange-inline">11</del>-Construction-d-une-BD.ppt<del class="diffchange diffchange-inline">]</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| Chap-<ins class="diffchange diffchange-inline">12</ins>-Construction-d-une-BD.ppt</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le modèle Entité-association de base</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Le modèle Entité-association de base</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| Chapitre <del class="diffchange diffchange-inline">12</del>&lt;br&gt;Annexe <del class="diffchange diffchange-inline">A12</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| Chapitre <ins class="diffchange diffchange-inline">13</ins>&lt;br&gt;Annexe <ins class="diffchange diffchange-inline">A13</ins></div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| <del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod</del>-<del class="diffchange diffchange-inline">2018/Chapitres/Chapitre-12/JLH-12-Modele-EA-de-base.ppt Chap</del>-<del class="diffchange diffchange-inline">12</del>-Modele-EA-de-base.ppt<del class="diffchange diffchange-inline">]</del>&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-12/JLH-A12-Modele-EA-de-base.pdf A12-Modele-EA-de-base.pdf]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">BD</ins>-<ins class="diffchange diffchange-inline">2022</ins>-<ins class="diffchange diffchange-inline">13</ins>-Modele-EA-de-base.ppt&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-12/JLH-A12-Modele-EA-de-base.pdf A12-Modele-EA-de-base.pdf]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Elaboration d'un schéma conceptuel</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Elaboration d'un schéma conceptuel</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| Chapitre <del class="diffchange diffchange-inline">13</del>&lt;br&gt;Annexe <del class="diffchange diffchange-inline">A13</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| Chapitre <ins class="diffchange diffchange-inline">14</ins>&lt;br&gt;Annexe <ins class="diffchange diffchange-inline">A14</ins></div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| <del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod</del>-<del class="diffchange diffchange-inline">2018/Chapitres/Chapitre</del>-<del class="diffchange diffchange-inline">13/JLH-13-Elaboration-d-un-schema-conceptuel.ppt Chap</del>-<del class="diffchange diffchange-inline">13</del>-Elaboration-d-un-schema-conceptuel.ppt<del class="diffchange diffchange-inline">]</del>&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-13/JLH-A13-Elaboration-d-un-schema-conceptuel.pdf A13-Elaboration-d-un-schema-conceptuel.pdf]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">BD</ins>-<ins class="diffchange diffchange-inline">2022</ins>-<ins class="diffchange diffchange-inline">2022</ins>-<ins class="diffchange diffchange-inline">14</ins>-Elaboration-d-un-schema-conceptuel.ppt&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-13/JLH-A13-Elaboration-d-un-schema-conceptuel.pdf A13-Elaboration-d-un-schema-conceptuel.pdf]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Production du schéma de la BD</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Production du schéma de la BD</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| Chapitre <del class="diffchange diffchange-inline">14</del>&lt;br&gt;Annexe <del class="diffchange diffchange-inline">A14</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| Chapitre <ins class="diffchange diffchange-inline">15</ins>&lt;br&gt;Annexe <ins class="diffchange diffchange-inline">A15</ins></div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| <del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod</del>-<del class="diffchange diffchange-inline">2018/Chapitres/Chapitre</del>-<del class="diffchange diffchange-inline">14/JLH-14-Production-du-schema-de-la-BD.ppt Chap</del>-<del class="diffchange diffchange-inline">14</del>-Production-du-schema-de-la-BD.ppt<del class="diffchange diffchange-inline">]</del>&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-14/JLH-A14-Production-du-schema-de-la-BD.pdf A14-Production-du-schema-de-la-BD.pdf]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">BD</ins>-<ins class="diffchange diffchange-inline">2022</ins>-<ins class="diffchange diffchange-inline">2022</ins>-<ins class="diffchange diffchange-inline">15</ins>-Production-du-schema-de-la-BD.ppt&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-14/JLH-A14-Production-du-schema-de-la-BD.pdf A14-Production-du-schema-de-la-BD.pdf]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Etudes de cas</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Etudes de cas</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| Chapitre <del class="diffchange diffchange-inline">23</del>&lt;br&gt;Annexe <del class="diffchange diffchange-inline">A23</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| Chapitre <ins class="diffchange diffchange-inline">24</ins>&lt;br&gt;Annexe <ins class="diffchange diffchange-inline">A24</ins></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| &lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-23/JLH-A23-Etudes-de-cas.pdf A23-Etudes-de-cas.pdf]</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| &lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-23/JLH-A23-Etudes-de-cas.pdf A23-Etudes-de-cas.pdf]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td colspan="2" class="diff-lineno">Ligne 73 :</td> <td colspan="2" class="diff-lineno">Ligne 73 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Mise à niveau</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Mise à niveau</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| Annexe <del class="diffchange diffchange-inline">A24</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| Annexe <ins class="diffchange diffchange-inline">A25</ins></div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| <del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Annexes/JLH-A24-Ensembles-et-Logique.pdf A24</del>-Ensembles-et-Logique.pdf<del class="diffchange diffchange-inline">]</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">A25</ins>-Ensembles-et-Logique.pdf</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Conventions graphiques</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>| Conventions graphiques</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| Annexe <del class="diffchange diffchange-inline">A29</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| Annexe <ins class="diffchange diffchange-inline">A30</ins></div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| <del class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Annexes/JLH-A29-Graphique-ER.pdf A29</del>-Graphique-ER.pdf]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">A30</ins>-Graphique-ER.pdf]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|}</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>|}</div></td></tr> </table> Dbm https://projects.info.unamur.be/~dbm/mediawiki/index.php?title=DUNOD2022_Cours_introductif&diff=2022&oldid=prev Dbm le 3 juillet 2022 à 17:44 2022-07-03T17:44:53Z <p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Version précédente</td> <td colspan='2' style="background-color: white; color:black;">Version du 3 juillet 2022 à 17:44</td> </tr><tr><td colspan="2" class="diff-lineno">Ligne 5 :</td> <td colspan="2" class="diff-lineno">Ligne 5 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>:Les documents de support du cours se présentent sous la forme de diaporamas en Powerpoint. Les annexes contiennent des exercices et leurs solutions ainsi que des compléments d'information.</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>:Les documents de support du cours se présentent sous la forme de diaporamas en Powerpoint. Les annexes contiennent des exercices et leurs solutions ainsi que des compléments d'information.</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>[[<del class="diffchange diffchange-inline">DUNOD2018</del>|&lt;Retour à la page de l'ouvrage&gt;]]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>[[<ins class="diffchange diffchange-inline">DUNOD2022</ins>|&lt;Retour à la page de l'ouvrage&gt;]]</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>{| border=&quot;1&quot;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>{| border=&quot;1&quot;</div></td></tr> </table> Dbm https://projects.info.unamur.be/~dbm/mediawiki/index.php?title=DUNOD2022_Cours_introductif&diff=2019&oldid=prev Dbm le 3 juillet 2022 à 17:41 2022-07-03T17:41:50Z <p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Version précédente</td> <td colspan='2' style="background-color: white; color:black;">Version du 3 juillet 2022 à 17:41</td> </tr><tr><td colspan="2" class="diff-lineno">Ligne 1 :</td> <td colspan="2" class="diff-lineno">Ligne 1 :</td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&lt;<del class="diffchange diffchange-inline">big</del>&gt;<del class="diffchange diffchange-inline">programme </del>de <del class="diffchange diffchange-inline">cours introductif</del>&lt;/<del class="diffchange diffchange-inline">big</del>&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">'''PROGRAMME DE COURS INTRODUCTIF (version 2022)'''</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">:Ce premier parcours est proposé au lecteur débutant, désireux d'aborder l'essentiel des concepts des bases de données, du langage SQL et des méthodes de construction d'une base de données sans toutefois rentrer dans trop de détails. Au terme de ce parcours, le lecteur sera à même de comprendre les enjeux, les problèmes et les solutions propres au domaine des bases de données. Sur le plan pratique, il sera capable d'interroger une base de données de complexité moyenne à l'aide du langage SQL. Il aura enfin suffisamment d'assurance pour construire de manière systématique et raisonnée de petites bases de données de faible complexité. </ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">:Les documents de support du cours se présentent sous la forme de diaporamas en Powerpoint. Les annexes contiennent des exercices et leurs solutions ainsi que des compléments d'information.</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">[[DUNOD2018|</ins>&lt;<ins class="diffchange diffchange-inline">Retour à la page de l'ouvrage</ins>&gt;<ins class="diffchange diffchange-inline">]]</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">{| border=&quot;1&quot;</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| colspan=&quot;3&quot; | &lt;center&gt;'''CONCEPTS DES BASES DE DONNEES'''&lt;/center&gt;</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| bgcolor=&quot;#00FF00&quot; | Leçon</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| bgcolor=&quot;#00FF00&quot; | Parties </ins>de <ins class="diffchange diffchange-inline">l'ouvrage</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| bgcolor=&quot;#00FF00&quot; | Ressources</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Motivation et introduction</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Chapitre 1</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| [http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-01/JLH-01-Motivation-et-introduction.ppt Chap-01-Motivation-et-introduction.ppt]</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Concepts des bases de données</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Chapitre 2</ins>&lt;<ins class="diffchange diffchange-inline">br&gt;Annexe A02&lt;br&gt;Compléments&lt;br&gt;&lt;br&gt;</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| [http:</ins>/<ins class="diffchange diffchange-inline">/www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/JLH-02-Concepts-des-bases-de-donnees.ppt Chap-02-Concepts-des-bases-de-donnees.ppt]&lt;br</ins>&gt;<ins class="diffchange diffchange-inline">[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/JLH-A02-Concepts-des-bases-de-donnees.pdf A02-Concepts-des-bases-de-donnees.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/Schema-CLICOM.pdf Schema-CLICOM.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-02/Chapitre-02-Scripts-SQLfast.zip Chap-02-Scripts.zip]</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| colspan=&quot;3&quot; | &lt;center&gt;'''UTILISATION DES BASES DE DONNEES'''&lt;/center&gt;</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| bgcolor=&quot;#00FF00&quot; | Leçon</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| bgcolor=&quot;#00FF00&quot; | Parties de l'ouvrage</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| bgcolor=&quot;#00FF00&quot; | Ressources</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Le langage SQL DDL</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Chapitre 6&lt;br&gt;Annexe A06&lt;br&gt;Compléments&lt;br&gt;&lt;br&gt;</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| [http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/JLH-06-SQL-DDL.ppt Chap-06-SQL-DDL.ppt]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/JLH-A06-Le-langage-SQL-DDL.pdf A06-Le-langage-SQL-DDL.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/SQL2-Syntax.pdf SQL2-Syntax.pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-06/Chapitre-06-Scripts-SQLfast.zip Chap-06-Scripts.zip]</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Le langage SQL DML (1)</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Chapitre 7&lt;br&gt;Annexe A07&lt;br&gt;Compléments</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| [http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-07/JLH-07-SQL-DML-(1).ppt Chap-07-SQL-DML-(1).ppt]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-07/JLH-A07-Le-langage-SQL-DML(1).pdf A07-Le-langage-SQL-DML(1).pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-07/Chapitre-07-Scripts-SQLfast.zip Chap-07-Scripts.zip]</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Le langage SQL DML (2)</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Chapitre 8&lt;br&gt;Annexe A08&lt;br&gt;Compléments</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| [http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-08/JLH-08-SQL-DML-(2).ppt Chap-08-SQL-DML-(2).ppt]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-08/JLH-A08-Le-langage-SQL-DML(2).pdf A08-Le-langage-SQL-DML(2).pdf]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-08/Chapitre-08-Scripts-SQLfast.zip Chap-08-Scripts.zip]</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| colspan=&quot;3&quot; | &lt;center&gt;'''DEVELOPPEMENT D'UNE BASE DE DONNEES'''&lt;/center&gt;</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| bgcolor=&quot;#00FF00&quot; | Leçon</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| bgcolor=&quot;#00FF00&quot; | Parties de l'ouvrage</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| bgcolor=&quot;#00FF00&quot; | Ressources</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Construction d'une BD</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Chapitre 11</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| [http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-11/JLH-11-Construction-d-une-BD.ppt Chap-11-Construction-d-une-BD.ppt]</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Le modèle Entité-association de base</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Chapitre 12&lt;br&gt;Annexe A12</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| [http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-12/JLH-12-Modele-EA-de-base.ppt Chap-12-Modele-EA-de-base.ppt]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-12/JLH-A12-Modele-EA-de-base.pdf A12-Modele-EA-de-base.pdf]</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Elaboration d'un schéma conceptuel</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Chapitre 13&lt;br&gt;Annexe A13</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| [http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-13/JLH-13-Elaboration-d-un-schema-conceptuel.ppt Chap-13-Elaboration-d-un-schema-conceptuel.ppt]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-13/JLH-A13-Elaboration-d-un-schema-conceptuel.pdf A13-Elaboration-d-un-schema-conceptuel.pdf]</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Production du schéma de la BD</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Chapitre 14&lt;br&gt;Annexe A14</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| [http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-14/JLH-14-Production-du-schema-de-la-BD.ppt Chap-14-Production-du-schema-de-la-BD.ppt]&lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-14/JLH-A14-Production-du-schema-de-la-BD.pdf A14-Production-du-schema-de-la-BD.pdf]</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Etudes de cas</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Chapitre 23&lt;br&gt;Annexe A23</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| &lt;br&gt;[http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Chapitres/Chapitre-23/JLH-A23-Etudes-de-cas.pdf A23-Etudes-de-cas.pdf]</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| colspan=&quot;3&quot; | &lt;center&gt;'''COMPLEMENTS FACULTATIFS'''&lt;/center&gt;</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| bgcolor=&quot;#00FF00&quot; | Leçon</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| bgcolor=&quot;#00FF00&quot; | Parties de l'ouvrage</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| bgcolor=&quot;#00FF00&quot; | Ressources</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Mise à niveau</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Annexe A24</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| [http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Annexes/JLH-A24-Ensembles-et-Logique.pdf A24-Ensembles-et-Logique.pdf]</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Conventions graphiques</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| Annexe A29</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">| [http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/Dunod-2018/Annexes/JLH-A29-Graphique-ER.pdf A29-Graphique-ER.pdf]</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">|}</ins></div></td></tr> </table> Dbm https://projects.info.unamur.be/~dbm/mediawiki/index.php?title=DUNOD2022_Cours_introductif&diff=2016&oldid=prev Dbm : Page créée avec « <big>programme de cours introductif</big> » 2022-07-03T14:44:38Z <p>Page créée avec « &lt;big&gt;programme de cours introductif&lt;/big&gt; »</p> <p><b>Nouvelle page</b></p><div>&lt;big&gt;programme de cours introductif&lt;/big&gt;</div> Dbm