ISS8AC

Database Essentials

 

ECTS Credits : 2

Duration : 21 hours

Semester : S8

Person(s) in charge :

Bart LAMIROY, Associate Professor, bart.lamiroy@mines-nancy.univ-lorraine.fr 

Keywords  : Relational databases, SQL, normalized forms, PL/SQL, NoSQL

Prerequisite :  Elementary algorithms, Imperative programming, some SQL notions are a plus

Objective:  Acquiring the databases systems modelling fundamentals.

 

 

1. introduction, issues, entity-association

 2. Relational, transition entity-association

 3. Normalized forms and coherent databases

 4. Transactional model, ACID

 5. Stocked procedures, triggers et PL/SQL

 6. Distributed models

 7. NoSQL


 

 

Abilities: 

Levels

Description and operationnal verbs

Know

The underlying  modelling mechanism, management, stocking and using big data, client relations

Understand 

the differences and complementarity between the data oriented modelling and the process oriented modelling (or algorithms)

Apply 

Scenarios and utilization modelling on concrete cases, with constraints of real situations

Analyse

modelling problems related to database relational model

Summarise

 

Assess

The adequate modelling solutions, their qualities, their limits, their performances, and the relevancy of its usage

Evaluations :

  • Written Test
  • Continuous Control
  • Oral report
  • Project
  • Written Report