| Objectif de l'enseignement |
| This course presents the fundamentals of Database Management Systems (DBMS) with emphasis on relational systems. |
| Contenus |
The theoretic part covers the following topics: DBMS functionalities, overview of the most common data models, the relational approach (algebra, normalization, etc.) and database design. We study database schema design using the entity-relationship model and introduce rules to translate an E/R schema into a relational one.
The pragmatic part of the course aims at familiarizing students with the use of the Standard Query Language (SQL). According to the specializations, the course can be completed by the development a multi-user database application using a relational DBMS. Students will use the Oracle 10g DBMS.
Textbooks
- T. Connolly et C. Begg, Systèmes de Bases de Données, Editions Reynald Goulet, 2005
- C. Delobel and M. Adiba, Bases de données et Systèmes Relationnels, Dunod informatique, 1982
- G. Gardarin, Bases de Données, Eyrolles, 2003.
- J.-L. Hainaut, Bases de données : Concepts, utilisation et développement, Dunod, 2009
- S. Navathe, R. Elamasri, Fundamentals of database systems, second ed., Adison-Wesley Pub, 1994
- J. Ullman, J. Widom, A First Course in Database Systems, Prentice-Hall, 1997
|
| Prerequis |
| None |
| EVALUATION |
| Final exam (3h) (E) |
N1=E1
N2=E2
|
| Travail personnel |
| 8 hours |
| Positionnement |
| | SLE:Obligatoire | | ISI:Obligatoire | | MIF:Obligatoire | | MMIS-AAD:Obligatoire | | MMIS-BIO:Obligatoire | | MMIS-IRV:Obligatoire | | MMIS-MCS:Obligatoire | | SIF:Obligatoire | | Télécom:Obligatoire | | Langue de l'Enseignement: | | FRANCAIS | |
|
| Bibliographie |
- J. Ullman, J. Widom, A First Course in Database Systems, Prentice-Hall, 1997
- S. Navathe, R. Elamasri, Fundamentals of database systems, second ed., Adison-Wesley Pub, 1994
- C. Delobel and M. Adiba, Bases de données et Systèmes Relationnels, Dunod informatique, 1982
| |
|