Génie industriel - Rubrique Formation - 2022

Information Systems Management - WGUS2044

  • Number of hours

    • Lectures 18.0
    • Projects -
    • Tutorials -
    • Internship -
    • Laboratory works 36.0
    • Written tests -

    ECTS

    ECTS 3.0

Goal(s)

At the end of this course, the students will be able to contribute to the implementation of an information system relevant to well-defined requirements. In particular, they will be able to:

  • Define the functional requirements and interfaces of an information system using the UML framework
  • Design system's components relevant to the functional requirements and interfaces using the UML framework
  • Write complex queries in SQL language
  • Develop and validate an information system with a DBMS

Responsible(s)

Abdourahim SYLLA

Content(s)

Lectures:
Challenges related to Information systems and databases - Database models and DBMS
UML modeling: Use case, Class, from UML class diagram to relational model
Relational Algebra and SQL Language

Tutorials:
UML modeling: Use case, Class, from UML class diagram to relational model
Relational Algebra and SQL Language
Implementation of queries with a DBMS
Structuring and importing data into a DBMS
Creating user interfaces with a DBMS

Project:
The goal of the project is to realize the entire process of an information system implementation through a case study inspired by a real industrial case. It is carried out in groups of two or three students. Four deliverables are expected: a project charter, UML diagrams presenting system specifications, a database and a collection of good practices. Each group can be asked to demonstrate the developed system.

Prerequisites

Project management, General computer science course (Semesters 1 & 2) and a practice of microsoft office basic tools (Word, Excel, Powerpoint).

Test

Three grades contribute to the final score (NF):

  • Project score (NP) for 40%
  • Final exam score (NE1) for 40%
  • Intermediate work score (ND) for 20%

Session 2 : only one grade is considered

  • A Final exam (NE2) (with the same modalities as the session 1's exam).

N1 = Final mark from 1st exam period
N2 = Final mark from 2nd exam period

NF session1 = 0,4*NP + 0,4*NE1 + 0,2*ND
NF session 2 = Max(NF session1, NE2)

To validate this course, each component of the final score (NF) must be greater than 0.
This weighting is compatible with the organisation of remote teaching and exams.

Each student's participation and investment are taken into account in their assessments.

The exam is given in english only FR

Calendar

The course exists in the following branches:

  • Curriculum - Master 1 GI program GID - Semester 7 (this course is given in english only EN)
  • Curriculum - Master 1 GI SIE program - Semester 7 (this course is given in english only EN)
see the course schedule for 2024-2025

Additional Information

Course ID : WGUS2044
Course language(s): FR

You can find this course among all other courses.

Bibliography

In the referenced web site http://www.g-scop.inpg.fr/~tollenam/msi-sie

Software tools manuals or Internet collaborative websites (developpez.com).
The Unified Modelling Language Reference Manual, J. Rumbaugh
CAD CAM, principles, Ch. McMahon, J. Browne.
Numerous WEB sites dedicated to the topics