Database Engineering [IHDCB334]
- 5 credits
- 30h
- 2nd quarter
Language of instruction: French / FrançaisTeacher: Cleve Anthony
Learning outcomes
At the end of the course, the (motivated) student will have acquired a good practical and theoretical knowledge of database concepts, SQL language and database design methodologies.
The student will be able to build in a systematic way a good quality database and to evaluate the quality and weaknesses of an existing database.
Content
The first part of the lecture describes practical elements of the relational theory, including topics such as relational algebra, functional dependencies, inclusion constraints and normalization.
The next parts study the principles of database design. They describe the standard database life cycle, Entity-relationship and UML conceptual models, as well as logical and physical models for SQL2. The lecture develops the main engineering processes : conceptual analysis, logical design, physical design and coding.
Teaching methods
The course is based on an alternation of oral presentations, supported by detailed slideshows, and exercises and case studies. The exercises are prepared at home then discussed during the course.
Evaluations
Three aspects are evaluated: theoretical and technical knowledge, ability to combine knowledge from various parts of the course and the capacity to solve practical problems. The written examination is 3 hour long. Books and personal notes not allowed.
Recommended readings
Hainaut, J.-L., Bases de données - Concepts, utilisation et développement, Coll. Sciences Sup, Dunod, Paris, 2012 (in French)
Date, C., J., An Introduction to Database Systems, Addison-Wesley, 2004 (1024 p.)
Garcia-Molina, H., Ullman, J., D., Widom, J., Database Systems - The complete Book, Prentice-Hall, 2008 (1248 p.)
Language of instruction
French / FrançaisLocation for course
NAMUROrganizer
Faculté d'informatiquerue Grandgagnage 21
5000 NAMUR
P. 081725252
F. 081724967
secretariat.info@unamur.be
