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/08/08 16:31] boverhae |
teaching:infoh303 [2008/08/11 17:58] ezimanyi |
||
|---|---|---|---|
| Line 29: | Line 29: | ||
| * Théorie 30 h - Exercices 30 h - Travaux Pratiques 30 h | * Théorie 30 h - Exercices 30 h - Travaux Pratiques 30 h | ||
| * 6 crédits ECTS | * 6 crédits ECTS | ||
| + | |||
| ===== Années d'études ===== | ===== Années d'études ===== | ||
| - | * 1ère année du master en ingénieur civil informatique [MA-IRIF] | + | * 3ème année du bachelier ingénieur civil informatique [IRCI3-T] |
| * 3ème année du bachelier en sciences informatiques [INFO3] | * 3ème année du bachelier en sciences informatiques [INFO3] | ||
| Line 50: | Line 51: | ||
| Le cours se donne pendant le premier semestre. | Le cours se donne pendant le premier semestre. | ||
| - | * [[teaching:infoh403:horaire|Horaire]] | + | * [[teaching:infoh303:horaire|Horaire]] |
| Line 75: | Line 76: | ||
| 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 81: | Line 83: | ||
| * [[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.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.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, 1er é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 88: | Line 90: | ||
| ===== Transparents du cours ===== | ===== Transparents du cours ===== | ||
| - | * {{teaching:infoh403:dbmsnotes.pdf|Database Management Systems}} | + | * {{teaching:infoh303:dbmsnotes.pdf|Database Management Systems}} |
| - | * {{teaching:infoh403:dbhistnotes.pdf|History of Database Technology}} | + | * {{teaching:infoh303:dbhistnotes.pdf|History of Database Technology}} |
| - | * {{teaching:infoh403:ernotes.pdf|Entity-Relationship Model}} | + | * {{teaching:infoh303:ernotes.pdf|Entity-Relationship Model}} |
| - | * {{teaching:infoh403:ertorelnotes.pdf|From Entity-Relationship to Relational Schemas}} | + | * {{teaching:infoh303:ertorelnotes.pdf|From Entity-Relationship to Relational Schemas}} |
| - | * {{teaching:infoh403:rdmnotes.pdf|Relational Databases}} | + | * {{teaching:infoh303:rdmnotes.pdf|Relational Databases}} |
| - | * {{teaching:infoh403:algnotes.pdf|Relational Algebra}} | + | * {{teaching:infoh303:algnotes.pdf|Relational Algebra}} |
| - | * {{teaching:infoh403:calculnotes.pdf|Relational Calculus}} | + | * {{teaching:infoh303:calculnotes.pdf|Relational Calculus}} |
| - | * {{teaching:infoh403:sqlnotes.pdf|SQL}} | + | * {{teaching:infoh303:sqlnotes.pdf|SQL}} |
| - | * {{teaching:infoh403:relnormnotes.pdf|Relational Normalization | + | * {{teaching:infoh303:relnormnotes.pdf|Relational Normalization |
| }} | }} | ||
| Line 102: | Line 104: | ||
| ===== Travaux Pratiques ===== | ===== Travaux Pratiques ===== | ||
| - | * [[teaching:infoh403:TP|Page web des travaux pratiques]] | + | * [[teaching:infoh303:TP|Page web des travaux pratiques]] |
| Line 118: | Line 120: | ||
| ===== Projet ===== | ===== Projet ===== | ||
| - | * [[:teaching:infoh403:projet|Page web des projets]] | + | * [[:teaching:infoh303:projet|Page web des projets]] |
| Line 138: | Line 140: | ||
| Certains anciens examens sont disponibles ci-dessous. | Certains anciens examens sont disponibles ci-dessous. | ||
| * Année académique 1999-2000 | * Année académique 1999-2000 | ||
| - | * {{teaching:infoh403:bd2000ex2s.pdf|Seconde session}} | + | * {{teaching:infoh303:bd2000ex2s.pdf|Seconde session}} |
| * Année académique 2000-2001 | * Année académique 2000-2001 | ||
| - | * {{teaching:infoh403:bd2001ex1s.pdf|Première session}} | + | * {{teaching:infoh303:bd2001ex1s.pdf|Première session}} |
| - | * {{teaching:infoh403:bd2001ex2s.pdf|Seconde session}} | + | * {{teaching:infoh303:bd2001ex2s.pdf|Seconde session}} |
| * Année académique 2001-2002 | * Année académique 2001-2002 | ||
| - | * {{teaching:infoh403:bd2002ex1s.pdf|Première session}} | + | * {{teaching:infoh303:bd2002ex1s.pdf|Première session}} |
| - | * {{teaching:infoh403:bd2002ex2s.pdf|Seconde session}} | + | * {{teaching:infoh303:bd2002ex2s.pdf|Seconde session}} |
| + | * Année académique 2007-2008 | ||
| + | * {{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}} | ||