{"id":61,"date":"2024-06-14T11:17:32","date_gmt":"2024-06-14T09:17:32","guid":{"rendered":"https:\/\/web.umons.ac.be\/sinf\/?page_id=61"},"modified":"2025-09-16T09:41:13","modified_gmt":"2025-09-16T07:41:13","slug":"bases-de-donnees-i","status":"publish","type":"page","link":"https:\/\/web.umons.ac.be\/sinf\/activites-denseignement\/bases-de-donnees-i\/","title":{"rendered":"Bases de Donn\u00e9es I"},"content":{"rendered":"<h2>Examen<\/h2>\n<p>Deux examens \u00e9crits seront organis\u00e9s: le premier concerne les TP SQL assur\u00e9s par M. Buys, le deuxi\u00e8me A CAHIER FERME concerne la th\u00e9orie. La pond\u00e9ration est (cours : 16, TP SQL : 4).<\/p>\n<p>Les \u00e9tudiants du bloc compl\u00e9mentaire sont dispens\u00e9 des TP SQL.<\/p>\n<h2>R\u00e9f\u00e9rences du cours<\/h2>\n<ul>\n<li>Le\n<div class=\"file-attachment\"><a href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2025\/09\/main20252026.pdf\" target=\"_blank\" rel=\"noopener\">syllabus<\/a>.<\/div>\n<\/li>\n<li>Les slides sur\n<div class=\"file-attachment\"><a href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2024\/09\/PKFK.pdf\" target=\"_blank\" rel=\"noopener\">PK et FK<\/a>.<\/div>\n<\/li>\n<li>Les slides sur\n<div class=\"file-attachment\"><a href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2024\/10\/SPJRUD-1.pdf\" target=\"_blank\" rel=\"noopener\">SPJRUD<\/a><\/div>\n<p>.<\/li>\n<li>Les slides sur\n<div class=\"file-attachment\"><a href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2024\/10\/introRelCalculus.pdf\">introduction au calcul relationnel<\/a>.<\/div>\n<\/li>\n<li>\n<div class=\"file-attachment\">Les slides sur\u00a0<a href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2024\/10\/SRC.pdf\" target=\"_blank\" rel=\"noopener\">le th\u00e9or\u00e8me de Codd<\/a>.<\/div>\n<\/li>\n<li style=\"font-size: 14px;\">Les slides sur\n<div class=\"file-attachment\" style=\"font-size: 14px;\"><a style=\"font-size: 14px;\" href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2024\/10\/TRC.pdf\" target=\"_blank\" rel=\"noopener\">tuple relational calculus<\/a>.<\/div>\n<\/li>\n<li>Les slides sur\n<div class=\"file-attachment\"><a href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2024\/06\/SQL.pdf\" target=\"_blank\" rel=\"noopener\">SQL\u00a0<\/a>.<\/div>\n<\/li>\n<li>Les slides sur\n<div class=\"file-attachment\"><a href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2024\/06\/FD3NF.pdf\" target=\"_blank\" rel=\"noopener\">BCNF et 3NF<\/a>.<\/div>\n<\/li>\n<li>\n<div class=\"file-attachment\">Slides\u00a0<a href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2024\/06\/concurrency.ppt\" target=\"_blank\" rel=\"noopener\">concurrency.ppt<\/a>.<a href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2024\/12\/concurrency.pdf\">concurrency.pdf<\/a><\/div>\n<\/li>\n<li>\n<div class=\"file-attachment\">Slides\u00a0<a href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2024\/06\/recovery.ppt\" target=\"_blank\" rel=\"noopener\">recovery.ppt<\/a><a href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2024\/12\/recovery.pdf\">recovery.pdf<\/a><\/div>\n<\/li>\n<li>\n<div class=\"file-attachment\">Slides\u00a0<a href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2024\/06\/2PLaddendum.pdf\" target=\"_blank\" rel=\"noopener\">2PL addendum<\/a>.<\/div>\n<\/li>\n<li>\n<div class=\"file-attachment\"><a href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2024\/06\/ER-1.pdf\" target=\"_blank\" rel=\"noopener\">ER<\/a><\/div>\n<\/li>\n<li>\n<div class=\"file-attachment\"><a href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2024\/06\/ERtoRel-1.pdf\" target=\"_blank\" rel=\"noopener\">ER vers Relationnel<\/a><\/div>\n<\/li>\n<li><a href=\"https:\/\/pdfs.semanticscholar.org\/9aaf\/a4657a4c2745062e423b63c05171eebf7e92.pdf\" target=\"_blank\" rel=\"noopener\">P. A. Bernstein, V. Hadzilacos, and N.Goodman:\u00a0<i>Concurrency Control and Recovery in Database Systems<\/i><\/a><\/li>\n<li><a href=\"http:\/\/web.cecs.pdx.edu\/~maier\/TheoryBook\/MAIER\/\" target=\"_blank\" rel=\"noopener\">D. Maier:\u00a0<i>The Theory of Relational Databases<\/i><\/a><\/li>\n<li><a href=\"http:\/\/webdam.inria.fr\/Alice\/\" target=\"_blank\" rel=\"noopener\">S. Abiteboul, R. Hull, V. Vianu:\u00a0<i>Foundations of Databases<\/i><\/a><\/li>\n<\/ul>\n<h2>Examens ant\u00e9rieurs<\/h2>\n<start-cask-shortcode-wrapper>    <div class=\"accordion content-block scheme-fs\">\n                <div class=\"accordion-inner\">\n            <div class=\"accordion-bellow\">\n                <button class=\"accordion-bellow-toggle scheme-background-hover\" data-target=\"#accordion-content-66719a1b253b2\">\n                    <span class=\"icon umons-icon-chevron-down\" aria-hidden=\"true\"><\/span> Examens ant\u00e9rieurs                <\/button>\n            <\/div>\n            <div id=\"accordion-content-66719a1b253b2\" class=\"accordion-content\">\n            \t<div class=\"inner editor-front\">\n            \t\t<start-cask-shortcode-wrapper><ul class=\"media-folder scheme-fs\">\n\t<\/ul><end-cask-shortcode-wrapper>\n            \t<\/div>\n            <\/div>\n        <\/div>\n            <\/div>\n<end-cask-shortcode-wrapper>\n<p>&nbsp;<\/p>\n<h2>Interpreter for the SPJRUD Algebra<\/h2>\n<p>Excellent tool developed by alumnus Sergio Mazzoleni. Here is a\u00a0<a href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2024\/06\/SPJRUDscreenshot.jpg\" target=\"_blank\" rel=\"noopener\">screenshot<\/a>.<br \/>\nThe tool is no longer available online as a web application. It can be downloaded and installed locally.<\/p>\n<h4>Local Installation<\/h4>\n<ul>\n<li>Download the\u00a0<a href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2024\/06\/spjrud_20160912.zip\" target=\"_blank\" rel=\"noopener\">tool<\/a>.<\/li>\n<li>Download the\u00a0<a href=\"https:\/\/web.umons.ac.be\/app\/uploads\/sites\/84\/2024\/06\/sqf_exemples_20160912.zip\" target=\"_blank\" rel=\"noopener\">example files<\/a>.<\/li>\n<li>Installation steps under Windows:\n<ul>\n<li>Since the tool is a web application, install\u00a0<a href=\"http:\/\/www.wampserver.com\/en\/\" target=\"_blank\" rel=\"noopener\">WampServer<\/a>\u00a0(say in C:\\wamp).<\/li>\n<li>Unzip the tool and copy it in C:\\wamp\\www<\/li>\n<li>In a recent version of Google Chrome or Firefox, open http:\/\/localhost\/spjrud_20160912\/spjrud\/index.html<br \/>\nThe tool may not work correctly in other browsers (and does not work in Internet Explorer).<\/li>\n<li>Click \u00ab\u00a0start SQF editor.\u00a0\u00bb<\/li>\n<li>Load one of the example files, e.g., exo_wijsen_02.sqf<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h4>Example<\/h4>\n<p>The following example illustrates the syntax.<\/p>\n<div class=\"highlighted-block\">\n<p>@let Likes = @relation[Drinker,Beer]<br \/>\n{&lt;Sergio, Orval&gt;<br \/>\n&lt;Sergio, Chimay&gt;<br \/>\n&lt;Sergio, La Trappe&gt;<br \/>\n&lt;Jef, Orval&gt;<br \/>\n&lt;Jef, Chimay&gt;<br \/>\n&lt;Jef, Duvel&gt;<br \/>\n&lt;Jan, Duvel&gt;<br \/>\n&lt;Jan, Orval&gt;}<\/p>\n<p>@let Trappists = @relation[Trappist, Country]<br \/>\n{&lt;Orval, Belgium&gt;<br \/>\n&lt;Chimay, Belgium&gt;<br \/>\n&lt;La Trappe, Netherlands&gt;}<\/p>\n<p>% Who likes all belgian trappists in the Trappists table ?<\/p>\n<p>@let Crossproduct = (@project {Drinker} Likes)<br \/>\n@join<br \/>\n(@rename {Trappist:Beer}<br \/>\n(@project{Trappist}<br \/>\n(@select {Country=\u00a0\u00bbBelgium\u00a0\u00bb} Trappists)))<\/p>\n<p>@let NotLikesAll = @project {Drinker} (Crossproduct @minus Likes)<\/p>\n<p>@let LikesAll = @project {Drinker} Likes @minus NotLikesAll<\/p>\n<p>@print LikesAll<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Examen Deux examens \u00e9crits seront organis\u00e9s: le premier concerne les TP SQL assur\u00e9s par M. Buys, le deuxi\u00e8me A CAHIER FERME concerne la th\u00e9orie. La pond\u00e9ration est (cours : 16, TP SQL : 4). Les \u00e9tudiants du bloc compl\u00e9mentaire sont dispens\u00e9 des TP SQL. R\u00e9f\u00e9rences du cours Le syllabus. Les slides sur PK et FK. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":11,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-61","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Bases de Donn\u00e9es I - Service \/ FS - Syst\u00e8mes d&#039;Information<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/web.umons.ac.be\/sinf\/activites-denseignement\/bases-de-donnees-i\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bases de Donn\u00e9es I - Service \/ FS - Syst\u00e8mes d&#039;Information\" \/>\n<meta property=\"og:description\" content=\"Examen Deux examens \u00e9crits seront organis\u00e9s: le premier concerne les TP SQL assur\u00e9s par M. Buys, le deuxi\u00e8me A CAHIER FERME concerne la th\u00e9orie. La pond\u00e9ration est (cours : 16, TP SQL : 4). Les \u00e9tudiants du bloc compl\u00e9mentaire sont dispens\u00e9 des TP SQL. R\u00e9f\u00e9rences du cours Le syllabus. Les slides sur PK et FK. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/web.umons.ac.be\/sinf\/activites-denseignement\/bases-de-donnees-i\/\" \/>\n<meta property=\"og:site_name\" content=\"Service \/ FS - Syst\u00e8mes d&#039;Information\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-16T07:41:13+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/web.umons.ac.be\/sinf\/activites-denseignement\/bases-de-donnees-i\/\",\"url\":\"https:\/\/web.umons.ac.be\/sinf\/activites-denseignement\/bases-de-donnees-i\/\",\"name\":\"Bases de Donn\u00e9es I - Service \/ FS - Syst\u00e8mes d'Information\",\"isPartOf\":{\"@id\":\"https:\/\/web.umons.ac.be\/sinf\/#website\"},\"datePublished\":\"2024-06-14T09:17:32+00:00\",\"dateModified\":\"2025-09-16T07:41:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/web.umons.ac.be\/sinf\/activites-denseignement\/bases-de-donnees-i\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/web.umons.ac.be\/sinf\/activites-denseignement\/bases-de-donnees-i\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/web.umons.ac.be\/sinf\/activites-denseignement\/bases-de-donnees-i\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/web.umons.ac.be\/sinf\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Activit\u00e9s d&rsquo;enseignement\",\"item\":\"https:\/\/web.umons.ac.be\/sinf\/activites-denseignement\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Bases de Donn\u00e9es I\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/web.umons.ac.be\/sinf\/#website\",\"url\":\"https:\/\/web.umons.ac.be\/sinf\/\",\"name\":\"Service \/ FS - Syst\u00e8mes d'Information\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/web.umons.ac.be\/sinf\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bases de Donn\u00e9es I - Service \/ FS - Syst\u00e8mes d'Information","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/web.umons.ac.be\/sinf\/activites-denseignement\/bases-de-donnees-i\/","og_locale":"fr_FR","og_type":"article","og_title":"Bases de Donn\u00e9es I - Service \/ FS - Syst\u00e8mes d'Information","og_description":"Examen Deux examens \u00e9crits seront organis\u00e9s: le premier concerne les TP SQL assur\u00e9s par M. Buys, le deuxi\u00e8me A CAHIER FERME concerne la th\u00e9orie. La pond\u00e9ration est (cours : 16, TP SQL : 4). Les \u00e9tudiants du bloc compl\u00e9mentaire sont dispens\u00e9 des TP SQL. R\u00e9f\u00e9rences du cours Le syllabus. Les slides sur PK et FK. [&hellip;]","og_url":"https:\/\/web.umons.ac.be\/sinf\/activites-denseignement\/bases-de-donnees-i\/","og_site_name":"Service \/ FS - Syst\u00e8mes d'Information","article_modified_time":"2025-09-16T07:41:13+00:00","twitter_card":"summary_large_image","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/web.umons.ac.be\/sinf\/activites-denseignement\/bases-de-donnees-i\/","url":"https:\/\/web.umons.ac.be\/sinf\/activites-denseignement\/bases-de-donnees-i\/","name":"Bases de Donn\u00e9es I - Service \/ FS - Syst\u00e8mes d'Information","isPartOf":{"@id":"https:\/\/web.umons.ac.be\/sinf\/#website"},"datePublished":"2024-06-14T09:17:32+00:00","dateModified":"2025-09-16T07:41:13+00:00","breadcrumb":{"@id":"https:\/\/web.umons.ac.be\/sinf\/activites-denseignement\/bases-de-donnees-i\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/web.umons.ac.be\/sinf\/activites-denseignement\/bases-de-donnees-i\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/web.umons.ac.be\/sinf\/activites-denseignement\/bases-de-donnees-i\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/web.umons.ac.be\/sinf\/"},{"@type":"ListItem","position":2,"name":"Activit\u00e9s d&rsquo;enseignement","item":"https:\/\/web.umons.ac.be\/sinf\/activites-denseignement\/"},{"@type":"ListItem","position":3,"name":"Bases de Donn\u00e9es I"}]},{"@type":"WebSite","@id":"https:\/\/web.umons.ac.be\/sinf\/#website","url":"https:\/\/web.umons.ac.be\/sinf\/","name":"Service \/ FS - Syst\u00e8mes d'Information","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/web.umons.ac.be\/sinf\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"}]}},"lang":"fr","translations":{"fr":61},"pll_sync_post":[],"_links":{"self":[{"href":"https:\/\/web.umons.ac.be\/sinf\/wp-json\/wp\/v2\/pages\/61","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/web.umons.ac.be\/sinf\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/web.umons.ac.be\/sinf\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/web.umons.ac.be\/sinf\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/web.umons.ac.be\/sinf\/wp-json\/wp\/v2\/comments?post=61"}],"version-history":[{"count":2,"href":"https:\/\/web.umons.ac.be\/sinf\/wp-json\/wp\/v2\/pages\/61\/revisions"}],"predecessor-version":[{"id":390,"href":"https:\/\/web.umons.ac.be\/sinf\/wp-json\/wp\/v2\/pages\/61\/revisions\/390"}],"up":[{"embeddable":true,"href":"https:\/\/web.umons.ac.be\/sinf\/wp-json\/wp\/v2\/pages\/11"}],"wp:attachment":[{"href":"https:\/\/web.umons.ac.be\/sinf\/wp-json\/wp\/v2\/media?parent=61"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}