Study programme 2020-2021Français
Database
Programme component of Bachelor's in Business Engineering à la Warocqué School of Business and Economics

Students are asked to consult the ECTS course descriptions for each learning activity (AA) to know what special Covid-19 assessment methods are possibly planned for the end of Q3

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çais30000033.002nd term

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

Objectives of Programme's Learning Outcomes

  • 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
  • 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
  • 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).

Content of UE

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 of Assessment for UE in Q2

  • Presentation and/or works
  • Written examination
  • Practical test

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 of Assessment for UE in Q3

  • Presentation and/or works
  • Practical Test
  • Graded tests

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
W-TICO-013
  • Cours magistraux

Mode of delivery

AAMode of delivery
W-TICO-012
  • Mixed
W-TICO-013
  • From a distance

Required Reading

AA
W-TICO-012
W-TICO-013

Required Learning Resources/Tools

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

Recommended Reading

AA
W-TICO-012
W-TICO-013

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 génération : 09/07/2021
20, place du Parc, B7000 Mons - Belgique
Tél: +32 (0)65 373111
Courriel: info.mons@umons.ac.be