Bases de Données

Relational Databases

Description: This course builds on the knowledge acquired in previous years to enable students to design effective database schemas and use relational database management systems (RDBMS). Topics include the entity-relationship model and its translation into the relational model (both systematic and heuristic approaches), functional dependencies, normalization (up to 3NF), SQL (except DCL), practice with 2 RDBMS, transactions, indexes, interacting with a database from within a program, SQL injection and parameterized queries, and an introduction to Object-Relational Mapping (ORM).

Learning outcomes: By the end of the course, students will be able to model a data system in relational form, implement the model, and manipulate the associated SQL database from within a program.

Evaluation methods: 1h30 written test, can be retaken.

Evaluated skills:

  • Modelling
  • System
  • Development

Course supervisor:

  • Virginie Galtier

Geode ID: SPM-INF-006

CM:

  1. Modélisation (1.5 h)
  2. SQL (1.5 h)
  3. ORM (1.5 h)

TD:

  1. Modélisation (1.5 h)

TP:

  1. SQL (1.5 h)
  2. Python (1.5 h)
  3. ORM (1.5 h)
  4. ouverture (3.0 h)
  5. mini projet (3.0 h)