Study programme 2018-2019Français
Databases I
Programme component of Bachelor's Degree in Mathematics à la Faculty of Science
CodeTypeHead of UE Department’s
contact details
Teacher(s)
US-B2-SCMATH-013-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çais304000066.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
Programme component

Objectives of Programme's Learning Outcomes

  • Understand "elementary" mathematics profoundly
    • Understand and use the naive set theory
    • Give examples and counterexamples for definitions, properties, theorems, etc.
  • Understand and produce strict mathematical reasoning
    • Use mathematical vocabulary and formalism appropriately
    • Make sense of formal expressions
  • Solve new problems
    • Abstract and manipulate theories and use these to solve problems

Learning Outcomes of UE

At the end of the course, the students will be able to:

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

Content of UE

The relational model.
Relational algebra.
Relational calculus.
SQL.
Normalization.
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 80%, SQL 20%.
 

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 80%, SQL 20%.
 

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
  • Travaux de laboratoire
  • Exercices de création et recherche en atelier
  • Projet sur ordinateur
  • Etudes de cas

Mode of delivery

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

Required Reading

AARequired Reading
S-INFO-005Note de cours - Bases de données I - Jef Wijsen
S-INFO-100
S-INFO-101

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

Recommended Reading

AARecommended Reading
S-INFO-005Travaux Pratiques - Partie 1 - Travaux Pratiques SQL - Alain Buys
S-INFO-100
S-INFO-101

Recommended Learning Resources/Tools

AARecommended Learning Resources/Tools
S-INFO-005Not applicable
S-INFO-100www.mysql.org
S-INFO-101Not 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
(*) 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 : 02/05/2019
20, place du Parc, B7000 Mons - Belgique
Tél: +32 (0)65 373111
Courriel: info.mons@umons.ac.be