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 information modeling. Entity-Relationship model. Relational databases and query languages. Dependency theory and relational database schema design. Physical data organization and implementation of the relational model. Transaction management. Deductive databases and XML.
Learning outcomes of the learning unit
The objective of this course is to acquire the knowledge necessary to implement information systems built around a database. At the end of the course, the student can build an application using a database and 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, which are followed by exercises.
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. This part will have to be done in teams of 2 students.
- The second part starts after the first part's deadline and ends at the beginning of May. Based on the work done in the first part, you will 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 3 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 and Sudarshan, 7th edition, McGraw-Hill, 2019 (or an earlier edition)
Exam(s) in session
Any session
- In-person
written exam ( open-ended questions )
Other : Project
Additional information:
project grade (40%), written exam (60%).
Amongst the 40% for the project, the first part is worth 10% and the second part 30%.
This project is mandatory. A student who would not have submitted anything for either part 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