Teaching directory
Course 2024-2025

Data management and engineering [EIMIB212]

  • 4 credits
  • 30h+15h
  • 2nd quarter
Language of instruction: French / Français

Learning outcomes

The general objective of this course is to learn how to manipulate and model information using the relational database approach. At the end of the course, the student should be able to: - Understand and use relational database concepts - Model a relational database - Formulate a query in relational algebra and SQL - Apply relational concepts in dataoriented applications

Content

The course focuses on relational databases. The approach of this course is based on theory combined with exercises. It is divided into 3 parts: - Concepts (the data model, normalisation) - Data manipulation (via relational algebra, SQL2 and SQL3) - Methodology (model, conceptual analysis, logical design)


Teaching methods

The teaching method is based on an alternation of lectures by the teacher and interactive work during which the students put into practice the concepts taught. Sample exercises will be presented and solved during the theoretical lectures. They will prepare the students for the exercises they will have to perform during the practical work. In order to give the students the opportunity to "feel" what a database management system is, the practical work will be done on a machine. Finally, students will be asked to work on a computer domain with a data-oriented approach.

Evaluations

Final exam (100%) which will consist of two parts: - Theoretical part: duration 2h (50%) - Practical part: duration 2h (50%)

Recommended readings

J-L Hainaut, Bases de données - Concepts, utilisation et développement, Dunod, 2009.

Language of instruction

French / Français

Location for course

NAMUR

Organizer

Faculté des sciences économiques, sociales et de gestion
Rue de Bruxelles, 61
5000 NAMUR

Degree of Reference

Undergraduate Degree