This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
teaching:infoh303 [2008/10/09 11:06] ezimanyi |
teaching:infoh303 [2019/02/19 12:17] gdejaege |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ~~NOTOC~~ | ||
+ | |||
====== INFO-H-303 : Bases de données ====== | ====== INFO-H-303 : Bases de données ====== | ||
- | + | <note tip> | |
- | + | [[http://cs.ulb.ac.be/public/teaching/infoh303#transparents_du_cours|Support de cours]]\\ | |
- | + | [[teaching:infoh303:horaire|Horaire]]\\ | |
- | + | [[teaching:infoh303:TP|Travaux pratiques]]\\ | |
- | + | [[teaching:infoh303:projet|Projets]] | |
- | + | </note> | |
- | + | ||
- | + | ||
- | + | ||
- | + | ||
===== Titulaire du cours ===== | ===== Titulaire du cours ===== | ||
Line 19: | Line 16: | ||
- | ===== Assistants ===== | + | ===== Assistant ===== |
- | * [[http://cs.ulb.ac.be/public/members/fservais|Frédéric Servais]] ([[fservais@ulb.ac.be]]) | + | * [[Gilles.Dejaegere@ulb.ac.be|Gilles Dejaegere]] |
- | * [[http://cs.ulb.ac.be/public/members/boris|Boris Verhaegen]] ([[boverhae@ulb.ac.be]]) | + | * [[apollari@ulb.ac.be|Arnaud Pollaris]] |
+ | * [[hugo.perilleux@ulb.ac.be|Hugo Perilleux]] | ||
+ | ===== Années d'études ===== | ||
+ | * 3ème année du bachelier ingénieur civil en informatique | ||
+ | * 2ème année du bachelier en sciences informatiques | ||
+ | * 1ère année du master en sciences géographiques | ||
- | ===== Volume ===== | ||
- | * Théorie 30 h - Exercices 30 h - Travaux Pratiques 30 h | ||
- | * 6 crédits ECTS | ||
- | ===== Années d'études ===== | ||
- | * 3ème année du bachelier ingénieur civil en informatique [IRCI3-T] | ||
- | * 3ème année du bachelier en sciences informatiques [INFO3] | ||
Line 43: | Line 39: | ||
+ | ===== Horaire et Plan du Cours ===== | ||
+ | * {{:teaching:infoh303:horaire_provisoire_2019.pdf|Plan du cours}} | ||
- | + | Ce plan du cours est provisoire. Veuillez-suivre les indications données sur l'UV (cours infoh303 2018-2019) pour l'information la plus à jour. | |
- | + | ||
- | + | ||
- | ===== Horaire ===== | + | |
- | + | ||
- | Le cours se donne pendant le premier semestre. | + | |
- | + | ||
- | * [[teaching:infoh303:horaire|Horaire]] | + | |
Line 77: | Line 68: | ||
Conception du schéma logique. Affinement du schéma logique. Dépendences fonctionnelles et multivaluées. Formes normales. Conception du schéma interne. | Conception du schéma logique. Affinement du schéma logique. Dépendences fonctionnelles et multivaluées. Formes normales. Conception du schéma interne. | ||
+ | |||
+ | |||
Line 82: | Line 75: | ||
===== Livres de référence ===== | ===== Livres de référence ===== | ||
- | * [[http://www.aw-bc.com/catalog/academic/product/0,4096,0321122267,00.html|R. Elmasri, S. Navathe, Fundamentals of Database Systems, 4e édition, Addison Wesley, 2004]]. | + | * [[http://www.pearsonhighered.com/educator/academic/product/1,,0136086209,00.html|R. Elmasri, S. Navathe, Fundamentals of Database Systems, 6e édition, Addison-Wesley, 2010]]. |
* [[http://www.aw-bc.com/catalog/academic/product/0,4096,0321197844,00.html|C. Date, An Introduction to Database Systems, 8e édition, Addison-Wesley, 2004]]. | * [[http://www.aw-bc.com/catalog/academic/product/0,4096,0321197844,00.html|C. Date, An Introduction to Database Systems, 8e édition, Addison-Wesley, 2004]]. | ||
* [[http://www.springer.com/dal/home/generic/search/results?SGWID=1-40109-22-97834894-0&SHORTCUT=www.springer.com/sgw/cda/frontpage/0,11855,1-40109-22-97834894-0,00.html|C. Parent,S. Spaccapietra, E. Zimányi Conceptual Modeling for Traditional and Spatio-Temporal Applications: The MADS Approach, 1e édition, Springer, 2006]]. | * [[http://www.springer.com/dal/home/generic/search/results?SGWID=1-40109-22-97834894-0&SHORTCUT=www.springer.com/sgw/cda/frontpage/0,11855,1-40109-22-97834894-0,00.html|C. Parent,S. Spaccapietra, E. Zimányi Conceptual Modeling for Traditional and Spatio-Temporal Applications: The MADS Approach, 1e édition, Springer, 2006]]. | ||
+ | |||
+ | |||
+ | |||
Line 100: | Line 96: | ||
===== Transparents du cours ===== | ===== Transparents du cours ===== | ||
- | Deux versions son disponibles: 4 transparents par page et 2 transparents par page | + | Deux versions sont disponibles : 4 transparents par page et 2 transparents par page |
* Database Management Systems: {{teaching:infoh303:dbmsnotes.pdf|4p}}, {{teaching:infoh303:dbmsnotes2p.pdf|2p}} | * Database Management Systems: {{teaching:infoh303:dbmsnotes.pdf|4p}}, {{teaching:infoh303:dbmsnotes2p.pdf|2p}} | ||
- | * History of Database Technology: {{teaching:infoh303:dbhistnotes.pdf|4p}}, {{teaching:infoh303:dbhistnotes2p.pdf|2p}} | ||
* Entity-Relationship Model: {{teaching:infoh303:ernotes.pdf|4p}}, {{teaching:infoh303:ernotes2p.pdf|2p}} | * Entity-Relationship Model: {{teaching:infoh303:ernotes.pdf|4p}}, {{teaching:infoh303:ernotes2p.pdf|2p}} | ||
+ | * Relational Databases: {{teaching:infoh303:rdmnotes.pdf|4p}}, {{teaching:infoh303:rdmnotes2p.pdf|2p}} | ||
* From Entity-Relationship to Relational Schemas: {{teaching:infoh303:ertorelnotes.pdf|4p}}, {{teaching:infoh303:ertorelnotes2p.pdf|2p}} | * From Entity-Relationship to Relational Schemas: {{teaching:infoh303:ertorelnotes.pdf|4p}}, {{teaching:infoh303:ertorelnotes2p.pdf|2p}} | ||
- | * {{teaching:infoh303:rdmnotes.pdf|Relational Databases}} | + | * Relational Algebra: {{teaching:infoh303:algnotes.pdf|4p}}, {{teaching:infoh303:algnotes2p.pdf|2p}} |
- | * {{teaching:infoh303:algnotes.pdf|Relational Algebra}} | + | * Relational Calculus: {{teaching:infoh303:calculnotes.pdf|4p}}, {{teaching:infoh303:calculnotes2p.pdf|2p}}, |
- | * {{teaching:infoh303:calculnotes.pdf|Relational Calculus}} | + | |
* SQL: {{teaching:infoh303:sqlnotes.pdf|4p}}, {{teaching:infoh303:sqlnotes2p.pdf|2p}} | * SQL: {{teaching:infoh303:sqlnotes.pdf|4p}}, {{teaching:infoh303:sqlnotes2p.pdf|2p}} | ||
* Relational Normalization: {{teaching:infoh303:relnormnotes.pdf|4p}}, {{teaching:infoh303:relnormnotes2p.pdf|2p}} | * Relational Normalization: {{teaching:infoh303:relnormnotes.pdf|4p}}, {{teaching:infoh303:relnormnotes2p.pdf|2p}} | ||
Line 117: | Line 112: | ||
+ | ===== Projets ===== | ||
+ | * [[teaching:infoh303:projet|Page web des Projets]] | ||
+ | * {{:teaching:infoh303:projet.pdf|Énoncé du projet 2017-2018}} | ||
+ | * Inscription à la défense (24 mai en UB4.329a): https://docs.google.com/spreadsheets/d/1vIE5rDvHepXbcU3I7Y8dVxfW4dZ-IhM9P7_uYIz5dI4/edit?usp=sharing | ||
Line 124: | Line 123: | ||
- | |||
- | |||
- | |||
- | |||
- | ===== Projet ===== | ||
- | |||
- | * [[:teaching:infoh303:projet|Page web des projets]] | ||
Line 160: | Line 152: | ||
* {{teaching:infoh303:infoh303_examen_0708_1s_th.pdf|Première session - Partie théorique}} | * {{teaching:infoh303:infoh303_examen_0708_1s_th.pdf|Première session - Partie théorique}} | ||
* {{teaching:infoh303:infoh303_examen_0708_1s_pr.pdf|Première session - Partie pratique}} | * {{teaching:infoh303:infoh303_examen_0708_1s_pr.pdf|Première session - Partie pratique}} | ||
+ | * Année académique 2008-2009 | ||
+ | * {{:teaching:infoh303:bdd_examen_0809_1s_th.pdf|Première session - Partie théorique}} | ||
+ | * {{:teaching:infoh303:bdd_examen_0809_1s_pr.pdf|Première session - Partie pratique}} |