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:05] ezimanyi |
teaching:infoh303 [2009/01/14 12:31] ezimanyi |
||
|---|---|---|---|
| Line 77: | Line 77: | ||
| 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 83: | ||
| ===== 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/0,3110,0321369572,00.html|R. Elmasri, S. Navathe, Fundamentals of Database Systems, 5e é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, 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 103: | Line 109: | ||
| * History of Database Technology: {{teaching:infoh303:dbhistnotes.pdf|4p}}, {{teaching:infoh303:dbhistnotes2p.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}} | ||
| - | * {{teaching:infoh303:ertorelnotes.pdf|From Entity-Relationship to Relational Schemas}} | + | * Relational Databases: {{teaching:infoh303:rdmnotes.pdf|4p}}, {{teaching:infoh303:rdmnotes2p.pdf|2p}} |
| - | * {{teaching:infoh303:rdmnotes.pdf|Relational Databases}} | + | * From Entity-Relationship to Relational Schemas: {{teaching:infoh303:ertorelnotes.pdf|4p}}, {{teaching:infoh303:ertorelnotes2p.pdf|2p}} |
| - | * {{teaching:infoh303:algnotes.pdf|Relational Algebra}} | + | * Relational Algebra: {{teaching:infoh303:algnotes.pdf|4p}}, {{teaching:infoh303:algnotes2p.pdf|2p}} |
| - | * {{teaching:infoh303:calculnotes.pdf|Relational Calculus}} | + | * Relational Calculus: {{teaching:infoh303:calculnotes.pdf|4p}}, {{teaching:infoh303:calculnotes2p.pdf|2p}}, |
| * 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}} | ||