Search Log in FR EN

Introduction aux bases de données relationnellesPO MRI 2 (STPI)

FISE STPI Semester 4 Pre-Orientation MRI 2 Machine translation

Introduction to Relational Databases

Teaching unit PO MRI 2
7ECTS (EU)
1.5Coefficient
22:00Hours

Séquencement

C TD C TD C TD C TD C TD C TD C TD C TD C TD TD TD TP TP TP TP TP

Learning objectives

  • The aim of this course is to introduce the concept of a relational database.
  • Database principles are addressed in two ways: modelling and operation.

Program

  • Introduction to databases,
  • Data modelling: model E/A,
  • Basic concepts: entity, relationship, property, cardinalities, functional dependencies,
  • Relationship model,
  • Relationship Structure: The normalization of relations,
  • Algebraic language,
  • SQL language,
  • Tables and constraints,
  • Requests, views.

References

  • Databases - Second ed. - Concepts, use and development, Jean-Luc Hainaut, Dunod, 2012.
  • Databases - from modelling to SQL, Laurent Audibert, Ellipse, 2009.
  • Nanci D., Espinasse B, "Ingénierie des systèmes d'information : MERISE 2°generation", Vuibert Informatique, 4°edition, 2001.