Data persistence II

Quadrimestre 3 -

24 hours

Coordinator : ARO

Teacher : ARO

General course description

The course deals with the principles governing SGDB relational database management systems.

Learning basic skills

  • Data Persistance: sequential, relative, sequentially indexed; basic principles of indexes, ...
  • Mathematics: principle of a whole, aggregational operators and features.

Course Outline

Chapter 1: Introduction (3 hours)

  • Limits of a file management system
  • Specifications for a database management system (SGDB)

Chapter 2: ANSI/SPARC Model (1 hours)

  • Internal, conceptual and external diagrams
  • Data dictionary

Chapter 3: Relational Model (14 hours)

  • Various generations of database management system (SGDB)
  • Basic concepts [fields, relation (diagram, extension, semantics), etc.]
  • Relational algebra (Union, product, selection, projection, juncture, etc.)
  • Relational languages
  • Standardization (functional dependency, relation keys, etc.)

Chapter 4: SQL (14 hours)

  • Components (DDL, DML, DCL)
  • DML
  • DDL
  • DCL principle of transaction

Bibliography

  • G. Gardarin, Bases de Données objet et relationnel, Eyrolles
  • J.-L. Hainaut, Bases de données et modèles de calcul, Dunod