Course 2022-2023

Database Engineering [INFOB212]

  • 3 credits
  • 45h+15h
  • 1st and 2nd quarter
Language of instruction: French / Français
Teacher: 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, database implementation techniques 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

PART 1 - Concepts Concepts of relational databases. SQL language (SQL2 and SQL3). PART 2 - Technology Data structures implementation. Database Management Systems. PART 3 - Methodology Database methodology. The relational model and normalisation. The Entity-relationship model and UML class diagrams. Conceptual analysis of the aplication domain. Logical design of a relational (and relational-object) database. Physical design of a relational database. Database reverse engineering.


Co-requisites

Méthodes de programmation [INFOB233]

Teaching methods

The course is delivered as a suite of lectures, each supported by a detailed slideshow. Exercises are organized during the course or as homework. Students, organized in small teams, carry out a large database design project.

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. There are two examination sessions (quadrimester 1 and 2), each 3 hour long and comprising 10 to 15 questions. 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çais

Location for course

NAMUR

Organizer

Faculté d'informatique
rue Grandgagnage 21
5000 NAMUR
P. 081725252
F. 081724967
secretariat.info@unamur.be

Degree of Reference

Undergraduate Degree