2017-2018 / INFO0009-1

Database (general organisation)

Duration

30h Th, 25h Pr, 25h Proj.

Number of credits

 Bachelor in engineering5 crédits 
 Bachelor in computer science5 crédits 
 Master in biomedical engineering (120 ECTS)5 crédits 
 Master in data science (120 ECTS)5 crédits 
 Master in data science and engineering (120 ECTS)5 crédits 
 Master in business engineering (120 ECTS)3 crédits 
 Master in bio-informatics and modelling (120 ECTS)6 crédits 
 Master in mathematics (120 ECTS)6 crédits 

Lecturer

Pierre Wolper

Language(s) of instruction

French language

Organisation and examination

Teaching in the second semester

Units courses prerequisite and corequisite

Prerequisite or corequisite units are presented within each program

Learning unit contents

Introduction to databases and to information modelling. Entity-Relationship model. Relational databases and query languages. Dependency theory and relational database schema design. Physical data organisation and implementation of the relational model. Transaction management. Deductive and object-oriented databases, data warehouses, XML.

Learning outcomes of the learning unit

The objective of this course is to acquire the knowledge necessary to implement information systems build around a database. At the end of the course, the student will be able to build an application exploiting a database and will have a good knowledge of the properties of database management systems.

Prerequisite knowledge and skills

Familiarity with programming.

Planned learning activities and teaching methods

Problems on the lecture material; project involving setting up a database and accessing it through a web interface.

Mode of delivery (face-to-face ; distance-learning)

2nd semester- face-to-face

Recommended or required readings

Slides available on the course web site

Assessment methods and criteria

project grade (30%), written exam (no oral exam).

Work placement(s)

Organizational remarks

More informlation about this course can be found at http://www.montefiore.ulg.ac.be/~pw/cours/bd.html

Contacts

Teacher : P. Wolper Tel.: 04 366 93 13 e-mail: Pierre.Wolper@ulg.ac.be Assistants: Samuel Hiard, Remy Vandaele