UCL - Studies

Version française

Study programmes
First cycle
Second cycle
Third cycle
Faculties and entities
Access to studies
Academic calendar
Search
Simple
Detailed
Per course

Files and databases [INGI1271]
[30h+30h exercises] 5 credits

Version française

Printable version

This course is taught in the 2nd semester

Teacher(s):

Alain Pirotte

Language:

French

Level:

First cycle

>> Aims
>> Main themes
>> Content and teaching methods
>> Other information (prerequisite, evaluation (assessment methods), course materials recommended readings, ...)
>> Other credits in programs

Aims

- To understand the main functions of a database-management system

- To understand the concepts and techniques underlying those functions

- To be able to represent in a database the information contents of an application domain

- To be able to implement a simple application involving database management (data structuring, and programming database queries and modifications)

Main themes

- Introduction to the entity-relationship model

- Bases of the relational model: data structures and algebra

- Logic-based relational languages to define and manipulate data

- Critical study of the SQL language

- Database application programming

- Functions and architecture of database-management systems

- Management of concurrent database accesses and associated techniques of recovery after failures

Content and teaching methods

see "Main themes"

Other information (prerequisite, evaluation (assessment methods), course materials recommended readings, ...)

- Prerequisites:
(1) INGI2101 Mathématiques discrètes: bases logiques de l'informatique A. van Lamsweerde
(2) LINF2121 Algorithmique et structures de données P. Dupont

- References:
(1) C. Date, "An Introduction to Database Systems", 7th Edition, Addison-Wesley, 2000
(2) R. Elmasri, S. Navathe, "Fundamentals of Database Systems", 4th Edition, Benjamin/Cummings, 2004
(3) H. Garcia-Molina, J. Ullman, J. Widom, "Database Systems: the Complete Book", Prentice Hall, 2002
(4) R. Ramakrishan and J. Gehrke, "Database Management Systems", McGraw-Hill, 3rd Edition, 2003

Other credits in programs

BIR22/0A

Deuxième année du programme conduisant au grade de bio-ingénieur: Sciences agronomiques (Technologies et gestion de l'information)

(5 credits)

Mandatory

BIR22/0C

Deuxième année du programme conduisant au grade de bio-ingénieur: chimie et bio-industries (Technologies & gestion de l'information)

(5 credits)

Mandatory

BIR22/0E

Deuxième année du programme conduisant au grade de bio-ingénieur: Sciences et technologies de l'environnement (Technologies et gestion de l'information)

(5 credits)

Mandatory

FSA13BA

Troisième année de bachelier en sciences de l'ingénieur, orientation ingénieur civil

(5 credits)

INFO22

Deuxième année du programme conduisant au grade d'ingénieur civil informaticien

(5 credits)

Mandatory

SINF13BA

Troisième année d'études de bachelier en sciences informatiques

(5 credits)

Mandatory

SINF1PM

Année d'études préparatoires au master en sciences informatiques (60 et 120)

(5 credits)

Mandatory

STAT21MS/DM

Première année du master en statistique, orientation générale, à finalité spécialisée (data management et data mining)

(5 credits)

STAT22MS/DM

Deuxième année du master en statistique, orientation générale, à finalité spécialisée (data management et data mining)

(5 credits)



This site was created in collaboration with ADCP, ADEF, CIO et SGSI
Person in charge : Jean-Louis Marchand - Information : secretaire@fsa.ucl.ac.be
Last update :13/03/2007