Study programme 2025-2026Français
Databases management
Programme component of Bachelor's in Engineering (CHARLEROI) (day schedule) à la Faculty of Engineering

CodeTypeHead of UE Department’s
contact details
Teacher(s)
UI-B3-IRCIVI-103-CCompulsory UEMAHMOUDI SidiF114 - Informatique, Logiciel et Intelligence artificielle
  • BENJELLOUN Mohammed
  • MAHMOUDI Sidi

Language
of instruction
Language
of assessment
HT(*) HTPE(*) HTPS(*) HR(*) HD(*) CreditsWeighting Term
  • Français
Français183000044.001st term

AA CodeTeaching Activity (AA) HT(*) HTPE(*) HTPS(*) HR(*) HD(*) Term Weighting
I-ILIA-103SQL and NoSQL database management1830000Q1100.00%

Programme component
Prérequis

Objectives of Programme's Learning Outcomes

  • Implement an engineering approach dealing with a set problem taking into account technical, economic and environmental constraints
    • Understand the stages of an engineering approach
    • Identify and describe the problem to be solved and the functional need (of prospective clients) to be met considering the state of technology
    • Design, evaluate and optimise solutions addressing the problem
    • Implement a chosen solution in the form of a drawing, a schema, a plan, a model, a prototype, software and/or digital model
    • Communicate the approach, results and prospects to a client or a board
    • Identify and acquire the information and skills needed to solve the problem
  • Understand the theoretical and methodological fundamentals in science and engineering to solve problems involving these disciplines
    • Identify, describe and explain basic scientific and mathematical principles
    • Identify, describe and explain the basic principles of engineering particularly in their specialising field
    • Select and rigorously apply knowledge, tools and methods in sciences and engineering to solve problems involving these disciplines
  • Understand the fundamentals of project management to carry out a set project, individually or as part of a team
    • Use the principles and tools of planning (time, tasks and resources)
    • Ensure a project is tracked and documented according to its specifications
    • Adapt the approach and achievements taking into account the feedback received
    • Respect deadlines and timescales
  • Communicate in a structured way - both orally and in writing, in French and English - giving clear, accurate, reasoned information
    • Argue to and persuade customers, teachers and a board both orally and in writing
    • Give an effective oral presentation, using presentation materials appropriately
    • Present analysis or experiment results in laboratory reports
  • Demonstrate thoroughness and independence throughout their studies
    • Identify the different fields and participants in engineering
    • Demonstrate self-awareness, asses themself, and develop appropriate learning strategies.
    • Learn to use various resources made available to inform and train independently

Learning Outcomes of UE

At the end of this course, students will be able to:
   - Construct a data model through relational algebra;
   - Manage the concepts, models, techniques and functionalities of a relational database management system;
   - Discover the concepts, principles and technologies of Big Data
At the end of this activity, students will be able to work in collaboration by implementing and communication skills through group work, public presentations and quality written reports

UE Content: description and pedagogical relevance

- Data presentation and modelisation tools ;
- Relational database management systems and query languages ;
- Implementation of relational database (analysis, design, structuring of data, etc.);
- Concepts, principles and technologies of Big Data.

Prior Experience

I-ILIA-100 ou I-ILIA-110 : Structures de données et algorithmes

Type of Teaching Activity/Activities

AAType of Teaching Activity/Activities
I-ILIA-103
  • Cours magistraux
  • Exercices dirigés
  • Démonstrations

Mode of delivery

AAMode of delivery
I-ILIA-103
  • Face-to-face

Required Learning Resources/Tools

AARequired Learning Resources/Tools
I-ILIA-103Not applicable

Recommended Learning Resources/Tools

AARecommended Learning Resources/Tools
I-ILIA-103Not applicable

Other Recommended Reading

AAOther Recommended Reading
I-ILIA-103Not applicable

Grade Deferrals of AAs from one year to the next

AAGrade Deferrals of AAs from one year to the next
I-ILIA-103Authorized

Term 1 Assessment - type

AAType(s) and mode(s) of Q1 assessment
I-ILIA-103
  • Written examination - Face-to-face
  • Production (written work, report, essay, collection, product, etc.) - To be submitted in class
  • Oral presentation - Face-to-face

Term 1 Assessment - comments

AATerm 1 Assessment - comments
I-ILIA-103Completion of a database management project during the term. Submission of the project report one week before the exam.
Oral presentation: group presentation (30 min) of the project carried out. Assessment criteria for the oral: technical quality of the project (modelling, SQL queries, interface and implementation), quality of the presentation, quality of the report; weighting 50%.
Written test: will focus on the theoretical concepts seen in the course (independent of the oral and the project); duration 1 hour; weighting 50%.

Resit Assessment - Term 1 (BAB1) - type

AAType(s) and mode(s) of Q1 resit assessment (BAB1)
I-ILIA-103
  • Written examination - Face-to-face
  • Production (written work, report, essay, collection, product, etc.) - To be submitted in class
  • Oral presentation - Face-to-face

Resit Assessment - Term 1 (BAB1) - Comments

AAResit Assessment - Term 1 (BAB1) - Comments
I-ILIA-103idem Q1

Term 3 Assessment - type

AAType(s) and mode(s) of Q3 assessment
I-ILIA-103
  • Written examination - Face-to-face
  • Production (written work, report, essay, collection, product, etc.) - To be submitted in class
  • Oral presentation - Face-to-face

Term 3 Assessment - comments

AATerm 3 Assessment - comments
I-ILIA-103idem Q1
(*) HT : Hours of theory - HTPE : Hours of in-class exercices - HTPS : hours of practical work - HD : HMiscellaneous time - HR : Hours of remedial classes. - Per. (Period), Y=Year, Q1=1st term et Q2=2nd term
Date de dernière mise à jour de la fiche ECTS par l'enseignant : 16/05/2025
Date de dernière génération automatique de la page : 14/03/2026
20, place du Parc, B7000 Mons - Belgique
Tél: +32 (0)65 373111
Courriel: info.mons@umons.ac.be