Study programme 2020-2021Français
Database
Programme component of Bachelor's in Management à 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-SCGEST-003-MOptional 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

  • Implement an academic view on knowledge, particularly through the mastery of methods and literature research tools.
    • Understand, synthesise and discuss complex information and texts on economics and management.
  • Actively master the fundamental concepts and models of economic sciences and management sciences
    • Identify and explain the concepts, principles and models of fundamental theoretical trends in economic sciences and management sciences and their applications.
    • Understand how organisations and markets work
  • Acquire basic methodological tools necessary for scientific inquiry in the field of economics and management.
    • Conduct relevant research from scientific literature and select appropriate elements with respect to a particular research topic.
  • 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
  • Actively master a knowledge base in human, legal and social sciences, essential for analysing problems in management.
    • Understand the implications of different human sciences on the way organisations and markets work.
    • Understand extensive problems in certain areas of management.
  • Implement an academic view on knowledge, particularly through the mastery of methods and literature research tools.
    • Understand, synthesise and discuss complex information and texts on economics and management.
  • Actively master the fundamental concepts and models of economic sciences and management sciences
    • Identify and explain the concepts, principles and models of fundamental theoretical trends in economic sciences and management sciences and their applications.
    • Understand how organisations and markets work
  • Acquire basic methodological tools necessary for scientific inquiry in the field of economics and management.
    • Conduct relevant research from scientific literature and select appropriate elements with respect to a particular research topic.
  • 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
  • Graded tests

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
  • Written examination
  • 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