Study programme 2019-2020Français
Databases I
Programme component of Master's in Computer Science à la Faculty of Science

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

CodeTypeHead of UE Department’s
contact details
Teacher(s)
US-MC-SCINFO-039-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çais302500055.001st term

AA CodeTeaching Activity (AA) HT(*) HTPE(*) HTPS(*) HR(*) HD(*) Term Weighting
S-INFO-005Databases I300000Q1
S-INFO-101Databases I (part B)025000Q1
Programme component

Objectives of Programme's Learning Outcomes

  • Have acquired highly specialised and integrated knowledge and broad skills in the various disciplines of computer science, which come after those within the Bachelor's in computer science.
  • Apply scientific methodology.
    • Demonstrate thoroughness, independence, creativity, intellectual honesty, and ethical values.

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

Q1 UE Assessment Comments

Written examination on the theory.
 

Type of Assessment for UE in Q3

  • Written examination

Q3 UE Assessment Comments

Written examination on the theory.

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-101
  • Travaux pratiques

Mode of delivery

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

Required Reading

AARequired Reading
S-INFO-005Note de cours - Partie 1 - Bases de données I (2019-2020) - Jef Wijsen
S-INFO-101

Required Learning Resources/Tools

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

Recommended Reading

AA
S-INFO-005
S-INFO-101

Recommended Learning Resources/Tools

AARecommended Learning Resources/Tools
S-INFO-005Not applicable
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-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 : 13/07/2020
20, place du Parc, B7000 Mons - Belgique
Tél: +32 (0)65 373111
Courriel: info.mons@umons.ac.be