Database design [ LSINF2172 ]

INGI1271 Systèmes de gestion de bases de données  (or equivalent)

• Database lifecycle
• Logical design, relational normalization
• Object-based models
• Other functions: active databases, temporal databases, database integration
• Physical representation: file organization, access structures
• Performance optimization: query-evaluation strategies, evaluation of relational operations, database tuning

• To be able to implement the various steps involved in building a complex database (conceptual modeling, physical storage, optimization, re-engineering)
• To understand and be able to adjust the implementation of functions offered by database-management systems

The contribution of this Teaching Unit to the development and command of the skills and learning outcomes of the programme(s) can be accessed at the end of this sheet, in the section entitled “Programmes/courses offering this Teaching Unit”.

• T. Connolly and C. Begg, "Database Systems: a Practical Approach to Design, Implementation, and Management", Addison-Wesley, 5th Edition, 2005
• R. Elmasri, S. Navathe, "Fundamentals of Database Systems", 4th Edition, Benjamin/Cummings, 2004
• H. Garcia-Molina, J. Ullman, J. Widom, "Database Systems: the Complete Book", Prentice Hall, 2002