Ensimag Rubrique Formation 2022

Principles of database management systemes(BD1) - 4MMPSGS1

  • Number of hours

    • Lectures 9.75
    • Projects -
    • Tutorials 17.25
    • Internship -
    • Laboratory works -
    • Written tests -

    ECTS

    ECTS 3.0

Goal(s)

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

Responsible(s)

Claudia RONCANCIO

Content(s)

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 DBMS fro the practical work.

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

Prerequisites

None

Test

Final exam (3h) (E1)

Controle de connaissances : : examen écrit, durée 3h, un feuille de notes autorisée (A4, recto-verso).

N1=E1
N2=E2 (examen de rattrapage)

Cas en distantiel:
N1 = (C1* Note extraite du projet) + C2*(Contrôle de connaissance réalisé à distance)

Calendar

The course exists in the following branches:

  • Curriculum - Information Systems Engineering - Semester 7
  • Curriculum - Financial Engineering - Semester 7
  • Curriculum - Math. Modelling, Image & Simulation - Semester 7
see the course schedule for 2023-2024

Additional Information

Course ID : 4MMPSGS1
Course language(s): FR

The course is attached to the following structures:

You can find this course among all other courses.

Bibliography

  • T. Connolly et C. Begg, Systèmes de Bases de Données, Editions Reynald Goulet, 2005
  • J.-L. Hainaut, Bases de données : Concepts, utilisation et développement, Dunod, 2009
  • J. Ullman, J. Widom, A First Course in Database Systems, Prentice-Hall, 1997