Study Programmes 2016-2017
| INFO0009-1 | |||||||||||||||||
| Database (general organisation) | |||||||||||||||||
|
Duration :
|
|||||||||||||||||
| 30h Th, 25h Pr, 25h Proj. | |||||||||||||||||
|
Number of credits :
|
|||||||||||||||||
|
|||||||||||||||||
|
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 3662099 e-mail: Pierre.Wolper@ulg.ac.be | |||||||||||||||||