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.
This course contributes to the learning outcomes I.1, I.2, II.1, II.2, III.1, III.2, III.3, V.1, VI.1, VI.2, VII.1, VII.4, VII.6 of the BSc in engineering.
This course contributes to the learning outcomes I.1, I.2, II.1, II.2, III.1, III.2, III.3, V.1, VI.1, VI.2, VII.1, VII.4, VII.6 of the MSc in biomedical engineering.
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
Recommended or required readings
Slides available on eCampus.
Reference book:
- Database System Concepts, Silberschatz, Korth en Sudarshan, 7de, McGraw-Hill, 9781260084504, 2019 (or an earlier edition)
Assessment methods and criteria
Exam(s) in session
Any session
- In-person
written exam ( open-ended questions )
Other : Project
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 information about this course can be found at eCampus.
Contacts
Lecturer: Christophe Debruyne Teaching assistant and demonstrator: TBD