Duration
20h Th, 10h Pr
Number of credits
| Master in public health (120 ECTS) (Transitional programme) | 3 crédits |
Lecturer
Language(s) of instruction
French language
Organisation and examination
Teaching in the second semester
Schedule
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, hybrid learning)
On site lecture
Recommended or required readings
A copy of the slideshow accompanying the session will be available before each lesson.
This is supporting material for the lesson and does not exhaustively cover the subject matter. Students are encouraged to take their own notes.
Exam(s) in session
Any session
- In-person
written exam ( multiple-choice questionnaire, open-ended questions )
- Remote
written exam ( multiple-choice questionnaire, open-ended questions ) AND oral exam
Continuous assessment
Additional information:
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.
Organisational adjustments related to the current health context :
If a "remote" examination must be organized, the written part (multiple-choice questionnaire, open-ended questions) will be shorter, but a mandatory oral exam of about 10 to 15 minutes will also be planned. The student MUST have a microphone and camera or webcam equiped computer. It is THAT oral exam which will establish the final grade.
Work placement(s)
Organisational remarks and main changes to the course
Contacts
By e-mail : yves.wesche@uliege.be
Please include course code (INFO0740-1) in mail subject