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, normal forms and normalization algorithms (up to 3NF), SQL statements for creating databases, use of a lightweight RDBMS, interacting with a database from within a program, the concept of ACID transactions, 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)