Study programme 2023-2024Français
Database
Programme component of Bachelor's in Business Engineering (MONS) (day schedule) à la Warocqué School of Business and Economics

CodeTypeHead of UE Department’s
contact details
Teacher(s)
UW-B3-IGGEST-001-MCompulsory UEVISEUR RobertW714 - Technologies de l'Information et de la Communication
  • VISEUR Robert

Language
of instruction
Language
of assessment
HT(*) HTPE(*) HTPS(*) HR(*) HD(*) CreditsWeighting Term
  • Français
Français24600033.002nd term

AA CodeTeaching Activity (AA) HT(*) HTPE(*) HTPS(*) HR(*) HD(*) Term Weighting
W-TICO-012Database - AAEP216000Q2
W-TICO-013Database - AAEHP30000Q2

Integrated test : there will be no assessment for each AA but a single assessment for the UE.
Programme component

Objectives of Programme's Learning Outcomes

  • Understand the scientific foundations of technological processes and the management of information flow and their respective involvement from a managerial point of view.
    • Understand the methods and tools adapted to the field of economics and management.
    • Understand the scientific fundamentals of production processes and their implications.
    • Understand extensive tools dedicated to the management of technological processes and the management of information flow.
  • Activate mathematical and computer models to insert them into analytical reasoning.
    • Understand the methods and quantitative tools adapted to the analysis of economic and management sciences.
    • Analyse and model a problem, by critically selecting appropriate theories.
  • Mobilise communication skills in two languages other than French, both orally and in writing, as a presentation of an argument or piece of research in accordance with scientific ethics.
    • Communicate in a clear and structured manner on issues of economics and management
    • Demonstrate an acute sense of analysis, criticism and ethics in relation to various issues in economics and management.
  • Critically compare knowledge acquired to real situations.
    • Demonstrate an acute sense of analysis, criticism and ethics in relation to various issues in economics and management.
  • Demonstrate working and analytical rigour.
    • Be rigorous and independent in learning, particularly through adequate planning of activities to be undertaken in order to best utilise the time available.
    • Develop their scientific curiosity and open-mindedness

Learning Outcomes of UE

At the end of the course, the students will be able to understand the basic concepts of relational databases, question a relational database using requests (SQL language) and understand the basic principles of the design of a relational database. They will also be aware of new data management technologies (eg NoSQL databases, full-text indexers and semantic databases).

UE Content: description and pedagogical relevance

Introduction to the databases. The relational model. Concepts of relational algebra. SQL language. Entity-Association Model. Data Security. NoSQL database. Full-text indexers.

Prior Experience

Not applicable

Type(s) and mode(s) of Q2 UE assessment

  • Written examination - Face-to-face
  • Production (written work, report, essay, collection, product, etc.) - To be submitted online
  • Graded assignment(s) - Face-to-face
  • Practical exam - Face-to-face

Q2 UE Assessment Comments

Written examination (100%). The students have to answer to theoretical questions and to solve a number of exercises (formulating queries, designing an Entity-Relationship diagram,...).

Type(s) and mode(s) of Q3 UE assessment

  • Written examination - Face-to-face
  • Production (written work, report, essay, collection, product, etc.) - To be submitted online
  • Graded assignment(s) - Face-to-face
  • Practical exam - Face-to-face

Q3 UE Assessment Comments

Written examination (100%). The students have to answer to theoretical questions and to solve a number of exercises (formulating queries, designing an Entity-Relationship diagram,...).

Type of Teaching Activity/Activities

AAType of Teaching Activity/Activities
W-TICO-012
  • Cours magistraux
  • Travaux pratiques
W-TICO-013
  • Cours magistraux

Mode of delivery

AAMode of delivery
W-TICO-012
  • Face-to-face
W-TICO-013
  • Remote

Required Learning Resources/Tools

AARequired Learning Resources/Tools
W-TICO-012Not applicable
W-TICO-013Not applicable

Recommended Learning Resources/Tools

AARecommended Learning Resources/Tools
W-TICO-012Not applicable
W-TICO-013Not applicable

Other Recommended Reading

AAOther Recommended Reading
W-TICO-012Not applicable
W-TICO-013Not applicable
(*) 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 : 14/05/2023
Date de dernière génération automatique de la page : 27/04/2024
20, place du Parc, B7000 Mons - Belgique
Tél: +32 (0)65 373111
Courriel: info.mons@umons.ac.be