Duration
26h Th, 26h Pr, 25h Proj.
Number of credits
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
Introduction to databases and to information modelling. Entity-Relationship model. Relational databases and query languages. Dependency theory and relational database schema design. Physical data organisation and implementation of the relational model. Transaction management. Deductive and object-oriented databases, data warehouses, XML, Block-chain.
Learning outcomes of the learning unit
The objective of this course is to acquire the knowledge necessary to implement information systems build around a database. At the end of the course, the student will be able to build an application exploiting a database and will have a good knowledge of the properties of database management systems.
Prerequisite knowledge and skills
Familiarity with programming.
Planned learning activities and teaching methods
Theoretical lessons followed by problems on the lecture material.
Project involving setting up a database and accessing it through a web interface.
This project will be split into two parts.
The first part starts at the beginning of March and ends about 3 weeks later, and consists in the making of an entity-relationship diagram, the conversion into the relational model, and possibly normalizing.
The second part starts after the first part's deadline and ends at the beginning of May. You will, based on the work done in the first part, design and develop the database and its web interface. An entity-relationship model as well as some data will be provided. This part will have to be done in teams of students.
Mode of delivery (face to face, distance learning, hybrid learning)
2nd semester- face-to-face
Organisational adjustments related to the current health context
Recommended or required readings
Slides available on the course web site.
Updated slides will be available on the exercices' webpage. These are to be used preferably with respect to the slides that are available on Prof. Wolper's webpage.
Assessment methods and criteria
Below you will find information on the evaluation methods planned for in-person and remote exams as well as those planned for hybrid sessions. Depending on how the health crisis evolves, the chosen method will be communicated to you no later than one month before the start of the exam session.
Any session :
- In-person
written exam ( open-ended questions )
- Remote
written exam
- If evaluation in "hybrid"
preferred in-person
Additional information:
project grade (30%), written exam (70%), no oral exam.
Amongst the 30% for the project, the first part is worth 10% and the second part 20%.
This project is mandatory. A student who would not have submitted anything for both parts will automatically obtain an absence grade (A) for the totality of the course.
Work placement(s)
Organizational remarks
More informlation about this course can be found at http://www.montefiore.ulg.ac.be/~pw/cours/bd.html but use preferably the web page located at http://www.montefiore.ulg.ac.be/services/verif/cours/bd/exercices.html
Contacts
Teacher : Samuel Hiard and P. Wolper Tel.: 04 366 26 97 (SH) e-mail: S.Hiard@uliege.be et Pierre.Wolper@ulg.ac.be Assistants: Samuel Hiard and another assistant (to be confirmed)