Database design
[SINF2172]
[30h + 30h] 5 credits
This course is taught in the 2d semester.
Teacher(s): Manuel Kolp, Alain Pirotte(coord.), Marco Saerens
Language: French
Level: Second
Aims
- To understand and be able to adjust the implementation of functions offered by database-management systems
Main themes
- 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
Content and teaching methods
Other information (prerequisite, evaluation (assessment methods), course materials recommended readings, ...)
- References
(1) T. Connolly and C. Begg, "Database Systems: a Practical Approach to Design, Implementation, and Management", Addison-Wesley, 5th Edition, 2005
(2) R. Elmasri, S. Navathe, "Fundamentals of Database Systems", 4th Edition, Benjamin/Cummings, 2004
(3) H. Garcia-Molina, J. Ullman, J. Widom, "Database Systems: the Complete Book", Prentice Hall, 2002