Study programme 2021-2022Français
Database
Programme component of Bachelor's in Management (Charleroi (Hor. jour)) à la Warocqué School of Business and Economics

CodeTypeHead of UE Department’s
contact details
Teacher(s)
UW-B3-SCGEST-025-COptional 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-017Database - AAEP270000Q2
W-TICO-018Database - 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

  • Demonstrate working and analytical rigour.
    • Develop their scientific curiosity and open-mindedness
  • Demonstrate working and analytical rigour.
    • 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-017
  • Cours magistraux
W-TICO-018
  • Cours magistraux

Mode of delivery

AAMode of delivery
W-TICO-017
  • Mixed
W-TICO-018
  • From a distance

Required Reading

AA
W-TICO-017
W-TICO-018

Required Learning Resources/Tools

AARequired Learning Resources/Tools
W-TICO-017Not applicable
W-TICO-018Not applicable

Recommended Reading

AA
W-TICO-017
W-TICO-018

Recommended Learning Resources/Tools

AARecommended Learning Resources/Tools
W-TICO-017Not applicable
W-TICO-018Not applicable

Other Recommended Reading

AAOther Recommended Reading
W-TICO-017Not applicable
W-TICO-018Not 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 : 21/05/2021
Date de dernière génération automatique de la page : 06/05/2022
20, place du Parc, B7000 Mons - Belgique
Tél: +32 (0)65 373111
Courriel: info.mons@umons.ac.be