Number of hours
- Lectures 4.5
- Projects -
- Tutorials 15.0
- Internship -
- Laboratory works 9.0
- Written tests 1.5
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)
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.
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%
N1 = Final mark from 1st exam period
N1 = 0,4*NP + 0,4*NE1 + 0,2*ND
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.
Session 2 : only one grade is considered
- A Final exam (NE2) (with the same modalities as the session 1's exam).
N2 = Final mark from 2nd exam period
N2 = Max(NF session1, NE2)
The exam is given in english only 
Calendar
The course exists in the following branches:
- Curriculum - Master 1 GI SIE program - Semester 7 (this course is given in english only
) - Curriculum - Master 1 GI program GID - Semester 7 (this course is given in english only )
Additional Information
Course ID : WGUS2044
Course language(s):
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