Information Systems and Databases 2

From a theoretical point of view, the notions and concepts addressed will cover the following themes

• Database design: extension of the E/A model and UML.

• Functional dependencies and normalization (transitive closure, coverage

  minimal, multivalued dependencies, Chase's algorithm, the different forms

  normal, etc.).

• SQL complements: data manipulation language (complex queries),

  data definition language, data control language

• Transactions

• Procedural language

• Trigger

• Index and optimization

  From a practical point of view, the database management system used during the lessons will be Oracle. Within the framework of the project, other systems such as MySQL or Postgres may be used.