Study programme 2021-2022Français
Databases I
Programme component of Bachelor's in Computer Science à la Faculty of Science

CodeTypeHead of UE Department’s
contact details
Teacher(s)
US-B2-SCINFO-003-MCompulsory UEWIJSEN JefS832 - Systèmes d'information
  • WIJSEN Jef

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

AA CodeTeaching Activity (AA) HT(*) HTPE(*) HTPS(*) HR(*) HD(*) Term Weighting
S-INFO-005Databases I300000Q1
S-INFO-100Databases I (part A)015000Q1
S-INFO-101Databases I (part B)025000Q1
S-INFO-102Databases I (part C)020000Q1

Overall mark : the assessments of each AA result in an overall mark for the UE.
Programme component

Objectives of Programme's Learning Outcomes

  • Understand the fundamentals of computer science
    • Show an understanding and deep knowledge of the concepts of computer science and mathematical formalisms used in the field of computer science
    • Solve exercises and computer problems by applying basic knowledge in the various disciplines of computer science
    • Use the vocabulary and the correct mathematical reasoning to formulate and solve problems in the field of computer science
  • Demonstrate basic knowledge and know-how in related fields
    • Demonstrate knowledge and basic skills in science and technology.
  • Manage IT projects
    • Manage a project in compliance with specifications, constraints and deadlines
  • Understand the fundamentals related to scientific methods
    • Develop skills of abstraction and modelling through a conceptual and scientific approach
    • Conduct rigorous reasoning based on scientific arguments

Learning Outcomes of UE

Design a relational database model.
Issue queries against a relational database.
Understand the functioning of a relational database system.

Content of UE

The relational data model.
Relational algebra.
Relational calculus (DRC, TRC).
SQL.
Normalization (3NF, BCNF, 4NF, 5NF).
Transaction management.

Prior Experience

Not applicable

Type of Assessment for UE in Q1

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

Q1 UE Assessment Comments

Written examination on the theory and written examination on SQL.
Weights: theory 70%, SQL 20%, personal project 10%.
 

Type of Assessment for UE in Q3

  • Presentation and/or works
  • Written examination

Q3 UE Assessment Comments

Written examination on the theory and written examination on SQL.
Weights: theory 70%, SQL 20%, personal project 10%.
 

Type of Resit Assessment for UE in Q1 (BAB1)

  • N/A

Q1 UE Resit Assessment Comments (BAB1)

Not applicable

Type of Teaching Activity/Activities

AAType of Teaching Activity/Activities
S-INFO-005
  • Cours magistraux
  • Conférences
S-INFO-100
  • Travaux pratiques
  • Travaux de laboratoire
  • Exercices de création et recherche en atelier
  • Projet sur ordinateur
  • Etudes de cas
S-INFO-101
  • Travaux pratiques
S-INFO-102
  • Projet sur ordinateur

Mode of delivery

AAMode of delivery
S-INFO-005
  • Face to face
S-INFO-100
  • Face to face
S-INFO-101
  • Face to face
S-INFO-102
  • Mixed

Required Reading

AA
S-INFO-005
S-INFO-100
S-INFO-101
S-INFO-102

Required Learning Resources/Tools

AARequired Learning Resources/Tools
S-INFO-005Web site with course notes, slides, and past examinations.
S-INFO-100Not applicable
S-INFO-101Not applicable
S-INFO-102Not applicable

Recommended Reading

AA
S-INFO-005
S-INFO-100
S-INFO-101
S-INFO-102

Recommended Learning Resources/Tools

AARecommended Learning Resources/Tools
S-INFO-005Not applicable
S-INFO-100www.mysql.org
S-INFO-101Not applicable
S-INFO-102Not applicable

Other Recommended Reading

AAOther Recommended Reading
S-INFO-005Serge Abiteboul, Richard Hull, Victor Vianu: Foundations of Databases. Addison-Wesley 1995, ISBN 0-201-53771-0

David Maier: The Theory of Relational Databases. Computer Science Press 1983, ISBN 0-914894-42-0

(both books are available online)
S-INFO-100Not applicable
S-INFO-101Not applicable
S-INFO-102Not 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/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