| 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