DataBase Management Systems

Duration

20h Th, 10h Pr

Number of credits

Lecturer

Yves Wesche

Language(s) of instruction

French language

Organisation and examination

Teaching in the second semester

Schedule

Schedule online

Units courses prerequisite and corequisite

Prerequisite or corequisite units are presented within each program

Learning unit contents

From small smartphones to gigantic datafarms, databases are everywhere. But when it comes to usability, size doesn't matter as much as conceptual, management and accessibility decisions. Choosing the right DataBase Management System (DBMS) is then critical.
Mastering a DBMS allows you to

• efficiently search for data;
• create optimized DB, knowing which abilities, issues and constraints are implied by the system and the data;
• share information with other systems.

Learning outcomes of the learning unit

At the end of the course, the student will be able to pin the DBMS on the Information System map. By creating, querying, cross-referring, importing and exporting simple data and small databases, he/she will be able to generalize it to bigger and real databases. But not without paying attention to issues coming with incomplete analysis, multi-users access, distibuted systems or incompatibilities, and trying to avoid them.

Prerequisite knowledge and skills

Planned learning activities and teaching methods

2 hours lecture followed by 1 hour practicals.
Some of the exercises will be graded, and are worth 50% of the total grade.

Mode of delivery (face-to-face ; distance-learning)

On site lecture

Recommended or required readings

A copy of the slideshow accompanying the session will be available after each class (see section 'Items online').
This is supporting material for the class and does not exhaustively cover the subject matter. Students are encouraged to take their own notes in class.
 

Assessment methods and criteria

In June and September :
- written examination (50%)

• the first part is a multiple-choice questionnaire, no notes allowed
• the second part is "open questions", students may bring their personnal, pre-existing, offline notes, but online notes or communications are forbidden

• those exercises, usually three or four, are carried out in class and are due before the end of the session. They cannot be carried out outside of the classroom, nor at a later date.

Work placement(s)

Organizational remarks

Contacts

By e-mail : yves.wesche@uliege.be
Please include course code (INFO0740-1) in mail subject

Adaptation of teaching commitments following the COVID-19 pandemic for the May-June 2020 session

Teaching methods implemented : distance-learning

Recordind of live courses, with slides, via podcast, available on my.uliege.be

Assessment subjects

Comparing to the complete matter, the 3 last chapters (Transactions, Normalisation and Introduction à MS-Access) will be simplified to focus on main principles.  Nonetheless, the complete slides will also be available to let the student go further.

Assessment methods

Written exam via eCampus (about 1h40) Oral exam via Lifesize or other visio-conference system (about 20 minutes) If available, one of the practicals will be graded (worth max 1/5 of the final score)

Contacts

Emergency contact with teacher during exam : 04/366.48.38

Adaptation of teaching commitments following the COVID-19 pandemic for the Aug-Sept 2020 session

Assessment subjects

Comparing to the complete matter, the 3 last chapters (Transactions, Normalisation and Introduction à MS-Access) will be simplified to focus on main principles. Nonetheless, the complete slides will also be available to let the student go further.

Assessment methods

Written exam via eCampus (about 1h40) Oral exam via Lifesize or other visio-conference system (about 20 minutes) The practicals grade is not included.

Contacts

Emergency contact with teacher during exam : 04/366.48.38

Items online