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 standardization (transitive closure, coverage, etc.)

  minimal, multivalued dependencies, Chase 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 will be Oracle. Other systems, such as MySQL or Postgres, may be used as part of the project.