| Course label : |
Information systems |
| Teaching departement : |
ING / Engineering |
| Teaching manager : |
Mister ERIC DANIEL |
| Education language : |
French |
| Potential ects : |
0 |
| Results grid : |
|
| Code and label (hp) : |
ITEEM_BACHELOR_ISY - Information systems |
Education team
Teachers : Mister ERIC DANIEL
External contributors (business, research, secondary education): various temporary teachers
Summary
The aim of this CSI module is to present the IS design process, from the drafting of specifications to the creation of the database in a database management system.
Educational goals
In terms of IS, they can analyze a set of specifications to produce a data dictionary.
Based on this data dictionary, they will transform the model into a Relational Model following
standardization rules. They will transform the model into a SQL script for creating tables, and implement the database in a DBMS. They will develop case studies that unfold the entire design methodology.
Sustainable development goals
Knowledge control procedures
Continuous Assessment
Comments: Case study: Design and modeling of an IS in the form of a relational model. Transformation of this relational model into a SQL script and implementation in a DBMS.
Online resources
Pedagogy
online relational modeling tool: dbdiagram.io
Sequencing / learning methods
| Number of hours - Lectures : |
0 |
| Number of hours - Tutorial : |
16 |
| Number of hours - Practical work : |
4 |
| Number of hours - Seminar : |
0 |
| Number of hours - Half-group seminar : |
0 |
| Number of student hours in TEA (Autonomous learning) : |
0 |
| Number of student hours in TNE (Non-supervised activities) : |
0 |
| Number of hours in CB (Fixed exams) : |
0 |
| Number of student hours in PER (Personal work) : |
0 |
| Number of hours - Projects : |
0 |
Prerequisites
Teaching module: Database Management
Maximum number of registrants
Remarks
Targeted skills
Block 01: Master digital business tools and industrial processes
- MAC 1B: Ability to extract data required for analysis,
control data quality and structure data
Block 06 : Develop a research approach in a professional context
- MAC 6A: Maintain a technology watch, collect reliable data
, use databases specific to the field of study
