2017-2018 / INFO0009-2

Database (general organisation) (partim)

Duration

25h Th, 25h Pr

Number of credits

 Master in biomedical engineering (120 ECTS)5 crédits 
 Bachelor in geography : general5 crédits 
 Master in geography : general (120 ECTS)5 crédits 
 Master in geography : geomatics and surveying (120 ECTS)5 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