| Course label : | Design and information systems |
|---|---|
| Teaching departement : | MIN / Applied Mathematics and General Computing |
| Teaching manager : | Mister MAXIME FOLSCHETTE |
| Education language : | French |
| Potential ects : | 0 |
| Results grid : | |
| Code and label (hp) : | LE2_3_IF_MIN_CSI - Conc. des systèmes d'Info. |
Education team
Teachers : Mister MAXIME FOLSCHETTE / Madam ISABELLE LE GLAZ / Mister ANIS GARGOURI / Mister HERVE CAMUS
External contributors (business, research, secondary education): various temporary teachers
Summary
This course is an introduction to information systems in general, and in particular to their modeling using the Merise entity-relationship model, and to software modeling using UML. It builds on prior knowledge from the “Systèmes d'Information et Applications” course in LE1 covering the relational model and SQL. It is divided into lectures and tutorials, which introduce the concepts and allow them to be applied immediately in written exercises, and practicals, which allow either computer implementation or longer exercises on more complex problems. Upon completion, students will be able to model certain parts of an information system, particularly the data model, based on specifications. This module will enable students to design an IT project.
Educational goals
After the course, students will be able to: - understand what an information system is and to what extent IT is integrated into it, - question the different ways in which a requirement can be modeled and identify their advantages, - design an entity-relationship model, - follow a design methodology (such as the Merise method: entity-relationship model, relational model, physical model), - read and understand an entity-relationship model, - understand a relational database architecture and use it with SQL queries, - understand and use the most common UML diagrams (sequence, use case, activity, class, and object diagrams). Knowledge covered: - general knowledge of business modeling, the role of an information system and its components, - Merise methodology and abstraction hierarchy: conceptual, logical, and physical levels, - sequence diagrams, use case diagrams, state diagrams, class diagrams, and object diagrams in UML. Skills developed: - designing an entity-relationship model from specifications, - designing a UML diagram from specifications, - understanding customer specifications, - understanding an entity-relationship model or a UML diagram provided, - translating an entity-relationship model into a relational model, then into an SQL script, - writing complex queries on the result.
Sustainable development goals
Knowledge control procedures
Continuous Assessment / Fixed Exam
Comments: Continuous assessment:
- written tests during tutorials,
- one or more practicals graded on the basis of the report produced during the session.
Final assessment:
- final written exam, without calculators or documents.
Online resources
Course slideshows. Possibly: online modeling tools such as diagrams.net. Application using a database with a MySQL or similar RDBMS, and phpMyAdmin interface.
Pedagogy
The entity-relationship model and UML are presented in tutorials, allowing for rapid practical application through exercises. Other general knowledge elements relating to information systems (business modeling) are also presented. Practicals allows students to apply the abstraction hierarchy (on computers) and work on longer exercises (on paper).
Sequencing / learning methods
| Number of hours - Lectures : | 0 |
|---|---|
| Number of hours - Tutorial : | 10 |
| Number of hours - Practical work : | 16 |
| 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
Course “Systèmes d'Information et Applications” in LE1: mastery of the relational model (design and understanding) and mastery of SQL. Mathematical logic, set theory.