Information systems management [EFASB240]
- 5 credits
- 30h
- 2nd quarter
Language of instruction: French / FrançaisTeacher: Faulkner Stéphane
Objectives
The main component of enterprise information systems are databases. The general objective of this course is to learn how to manipulate and model information using the relational database approach. At the end of the course, the student should be able to: • Understand and use relational database concepts • Model a relational database • Formulate a query in SQL • Apply relational concepts in data-driven applications
Content
The course focuses on relational databases. The approach of this course is based on theory combined with exercises. It is divided into 3 parts: • The concepts (the data model) • Data manipulation (via SQL2 and SQL3) • Methodology (model, conceptual analysis, logical design)
Teaching methods
The teaching method is based on an alternation of lectures by the teacher and interactive work during which the students put into practice the concepts taught. Sample exercises will be presented and solved during the theoretical lectures. They will prepare the students for the exercises they will have to perform during the practical work.
Evaluations
Final exam (100%) which will consist of two parts: • Theoretical part: duration 1h30 (50%) • Practical part: duration 1h30 (50%)
Recommended readings
J-L Hainaut, Bases de données - Concepts, utilisation et développement, Dunod, 2018.
Language of instruction
French / FrançaisLocation for course
NAMUROrganizer
Faculté des sciences économiques, sociales et de gestionRue de Bruxelles, 61
5000 NAMUR
