Course 2024-2025

Modeling for information systems [INFOB135]

  • 5 credits
  • 30h+10h
  • 2nd quarter
Language of instruction: French / Français
Teacher: Cleve Anthony

Learning outcomes

The course addresses the modeling of information systems through the database paradigm. It teach the student to rationally express typical problem situations in an appropriate formalism: data structures as tables, queries as SQL2 statements, semantic information structures as Entity-relationship schemas.
This course also is an introduction to databases.

Content

Part 1 - Concepts of relational databases. Elements of SQL language.
Part 2 - Database methodology. Basic Entity-relationship model. Building an Entity-relationship model. Producing a database schema.


Teaching methods

The course is delivered as a suite of lectures, each supported by a detailed slideshow. Exercises are organized during the course or as homework. Specific exercises on computer are organized.

Evaluations

Three aspects are evaluated: theoretical and technical knowledge, ability to combine knowledge from various parts of the course and the capacity to solve practical problems. The written examination is 3 hour long. Books and personal notes are not allowed.

Recommended readings

Hainaut, J.-L., Bases de données - Concepts, utilisation et développement, Coll. Sciences Sup, Dunod, Paris, 2012 (in French)

Language of instruction

French / Français

Location for course

NAMUR

Organizer

Faculté d'informatique
rue Grandgagnage 21
5000 NAMUR
P. 081725252
F. 081724967
secretariat.info@unamur.be

Degree of Reference

Undergraduate Degree