Information Systems Management - 4GUL1301

A+Augmenter la taille du texteA-Réduire la taille du texteImprimer le documentEnvoyer cette page par mail

Number of hours
- Lectures : 6.0
- Tutorials : 15.0
- Laboratory works : 9.0
- Projects : -
- Internship : -
- Written tests : 1.0
ECTS : 3.0
Officials : Abdourahim SYLLA

Goals

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 the Microsoft Access DBMS

Content

Lectures (4 x 1.5 h):
Challenges related to Information systems and databases - Database models and DBMS (1.5 h)
UML modeling: Use case, Classe, from UML class diagram to relational model (2 x 1.5 h)
Relational Algebra and SQL Language (1.5 h)

Tutorials (10 x 1.5 h):
UML modeling: Use case, Classe, from UML class diagram to relational model (3 x 1.5 h)
Relational Algebra and SQL Language (2 x 1.5 h)
Implementation of queries with the Access DBMS (2 x 1.5 h)
Structuring and importing data into the Access DBMS (1.5 h)
Creating user interfaces with the Access DBMS (2 x 1.5 h)

Project (3 x 3 h):
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. Two deliverables are expected: UML diagrams presenting system specifications and an Access database. Each group can be asked to demonstrate the developed system.

Prerequisites

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

Tests

Three grades contribute to the final score (NF):

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

NF = 0,4*NP + 0,4*NE + 0,2*ND

Pour valider cette UE, chaque composante de la Note Finale (NF) doit être supérieure à 0.
To validate this course, each component of the final score (NF) must be greater than 0.
Cette pondération est compatible avec une organisation des enseignements et des examens en distanciel

Calendar

The course exists in the following branches:

Curriculum - Engineer student Master SCM - Semester 7
Curriculum - M2 GI Operations Management - Semester 7

see the course schedule for 2021-2022

Additional Information

Course ID : 4GUL1301
Course language(s):

You can find this course among all other courses.

Bibliography

"Systèmes d'information : structuration, modélisation et communication", Jean Claude COURBON, InterEditions, 1993
"Des Bases de données à l'Internet" P. Mathieu, 2000, Ed Vuibert
"UML en action par Pascal Roques, Franck Vallée ISBN 2-212-09127-3 Editions Eyrolles
"Bases de données - de la modélisation au SQL", Laurent Audibert, eds Ellipses 2009
"UML 2 - de l'apprentissage à la pratique", Laurent Audibert, eds Ellipses 2009
http://josdblog.blogspot.fr/2009/09/livre-base-de-donnees-de-la.html
"Management des systèmes d'information", Kenneth Laudon, Jane Laudon, Eric Fimbel, Serge Costa, 11eme edition, 2011, PEARSON

Manuels des logiciels de Bases de Données utilisés ; notes de cours données sous forme de polycopiés.
nombreux sites Internet dédiés
Site du cours Internet http://www.g-scop.fr/~tollenam/msi
The Unified Modelling Language Reference Manual, J. Rumbaugh
CAD CAM, principles, ... Ch. McMahon, J. Browne.
Numerous WEB sites dedicated to the topics.