News
Our Degree Programs
Establishment
Language of instruction
French, English
Teaching content
MB-IT
This course occurs in the following program(s)
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