Principles of Relational data management

Catalog of Télécom SudParis courses

Code

IGSE CSC 7427

Semester

Spring

Domain

Informatique

Program

Master

Language

Anglais/English

ECTS Credits

2

Class hours

1,5

Workload

30

Program Manager(s)

Department

  • Informatique

Organisation

Cours/TD/TP/projet/examen : 1,5

Learning objectives

At the end of this course, the students will be able to:
- Identify the concepts relevant for the management of data
- Model and represent the data manipulated by an information system with a relational schema and an entity-relationship diagram and illustrate on different case studies
- Specify queries on a relational database
- Describe the concepts and techniques used for distributed transaction management
- Compare SQL and noSQL systems

Keywords

Data management, entity, association, class, UML, transaction, SQL, noSQL

Evaluation

Evaluation based on a final exam.

The final exam is taking place at the end (1.5 h on table).