Information Systems Management - 4GUL1301

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

Content(s)

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. 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 (Semesters 1 & 2) and a practice of microsoft office basic tools (Word, Excel, Powerpoint).