Establishment
Language of instruction
French, English
Teaching content
MB-IT
Training officer(s)
D.DELANNOY
Stakeholder(s)
D.DELANNOY, P. Hameau (IBM), V. Bracq (IBM)
Présentation
Prerequisite
To follow this module, the student must know the notions of databases (reading a Conceptual Data Model, SQL queries) and have implemented these notions.
Goal
Targeted skills : 32(321/323), 34(342/343), 43(431/432), 56(561/562), 63(634), 110(1102)
This module addresses the notions of data modeling based on the MERISE method and allows to understand the whole chain from conception to implementation in a relational database.
The orientation is suitable for all engineering profiles in software development, big data, connected objects, engineer of business domains
At the end of the course, the student will:
- Know the concept of Information System data modeling
- Be able to model the data of a Small Information System
- Know how to read a conceptual data model and transform it into tables
- Know the process of creating a database under PostgresSQL
- Know how to insert data into a database and select them according to different criteria
- Know how to select data in a database according to different criteria
This module addresses the notions of data modeling based on the MERISE method and allows to understand the whole chain from conception to implementation in a relational database.
The orientation is suitable for all engineering profiles in software development, big data, connected objects, engineer of business domains
At the end of the course, the student will:
- Know the concept of Information System data modeling
- Be able to model the data of a Small Information System
- Know how to read a conceptual data model and transform it into tables
- Know the process of creating a database under PostgresSQL
- Know how to insert data into a database and select them according to different criteria
- Know how to select data in a database according to different criteria
Presentation
This module covers the following topics:
- The role of modeling
- The relational principle of organization of information
- The presentation of the MERISE method
- The conceptual, logical and physical modeling
- The implementation of relational databases
- The principles of a Database Management System (DBMS)
- The description language of the database (SQL)
- The data manipulation language (SQL)
- The role of modeling
- The relational principle of organization of information
- The presentation of the MERISE method
- The conceptual, logical and physical modeling
- The implementation of relational databases
- The principles of a Database Management System (DBMS)
- The description language of the database (SQL)
- The data manipulation language (SQL)
Modalités
Organization
Type | Amount of time | Comment | |
---|---|---|---|
Face to face | |||
Lectures - face to face | 6,00 | ||
Exercises | 4,00 | ||
Lab | 8,00 | ||
Mini-project | 10,00 | ||
Independent study | |||
Independent study | 30,00 | ||
Overall student workload | 58,00 |
Evaluation