Aller au menu Aller au contenu
Our engineering & Master degrees


School of engineering in Physics, Applied Physics, Electronics & Materials
Science

Our engineering & Master degrees
Our engineering & Master degrees

> Studies

Principles of database management systems - 4PMIPSG1

A+Augmenter la taille du texteA-Réduire la taille du texteImprimer le documentEnvoyer cette page par mail cet article Facebook Twitter Linked In
  • Number of hours

    • Lectures : 12.0
    • Tutorials : 18.0
    • Laboratory works : 0
    • Projects : 0
    • Internship : 0
    • Written tests : -
    ECTS : 3.0
  • Officials : Claudia RONCANCIO

Goals

This course presents the fundamentals of Database Management Systems (DBMS) with emphasis on relational systems.

Contact Nils GESBERT

Content

The theoretic part covers the following topics: DBMS functionalities, overview of the most common data models, the relational approach and database design.
For the relational model we study the normalization theory, relational algebra and the Structured Query Language (SQL2) for data definition and manipulation.

Concerning database design we will work out 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). We will the Oracle 10g DBMS fro the practical work.

A complementary project is proposed to the develop a multi-user database application using a relational DBMS.



Prerequisites

None

Tests

Final exam (3h) (E)



N1=E1
N2=E2

Calendar

The course exists in the following branches:

  • Curriculum - Embedded Systems & Connect. Devices - Semester 8
see the course schedule for 2020-2021

Additional Information

Curriculum->Engineering degree->Semester 8

Bibliography

*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

A+Augmenter la taille du texteA-Réduire la taille du texteImprimer le documentEnvoyer cette page par mail cet article Facebook Twitter Linked In

Date of update June 30, 2020

Université Grenoble Alpes