> Studies > Engineering degree
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:
CTD (14 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 (3 x 1.5 h)
Relational Algebra and SQL Language (3 x 1.5 h)
Structuring and importing data into the Access DBMS (1.5 h)
Implementation of queries with the Access DBMS (3 x 1.5 h)
Creating user interfaces with the Access DBMS (3 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. Four deliverables are expected: a project charter, UML diagrams presenting system specifications, an Access database and a collection of good practices. Each group can be asked to demonstrate the developed system.
Project management, general computer science course and a practice of microsoft office basic tools (Word, Excel, Powerpoint).
Three grades contribute to the final score (NF):
NF = 0,45*NP + 0,45*NE + 0,1*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
The course exists in the following branches:
Course ID : 4GMA0413
Course language(s):
You can find this course among all other courses.
"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
Supports de cours, vidéos et sites web disponibles sur chamilo.