This course assumes that the student already masters the basic programming skills covered by courses LINFO1101 or LEPL1401 and the algorithmic concepts, simple data structures and Java programming concepts covered by course LEPL1402, or equivalent.
The prerequisite(s) for this Teaching Unit (Unité d’enseignement – UE) for the programmes/courses that offer this Teaching Unit are specified at the end of this sheet.
- Introduction to databases and data modeling;
- Object-oriented program design;
- Methodological assistance for program development;
- Development (analysis, design, implementation, documentation) of a Java program (Android) of medium complexity.
- 1 Given the learning outcomes of the "Bachelor in Engineering" program, this course contributes to the development, acquisition and evaluation of the following learning outcomes:
Given the learning outcomes of the "Bachelor in Computer science" program, this course contributes to the development, acquisition and evaluation of the following learning outcomes:
- AA1.1, AA1.2
Students completing successfully this course will be able to
- S1.I5, S1.I6
- rigorously model a software system (its data, structure and behaviour);
- design and implement a program of medium size and complexity in an object-oriented language;
- explain the essential concepts underlying database management systems;
- correctly use appropriate tools and methodologies to facilitate the design and development of programs and to manage a database.
The contribution of this Teaching Unit to the development and command of the skills and learning outcomes of the programme(s) can be accessed at the end of this sheet, in the section entitled “Programmes/courses offering this Teaching Unit”.
- introduction to databases
- data modelling (Object-Role Modelling)
- the relational schema
- query languages (SQL)
- the software development process
- requirements analysis (user stories)
- CRC cards (Classes, Roles and Responsibilities)
- class diagrams (UML)
- sequence diagrams (UML)
Participation in the practical sessions is obligatory. The tutors will take note of absences.
The final score for this course will be calculated as a weighted average of the scores of the different evaluations, but the student must achieve a score of at least 10/20 for both the exam AND the continuous evaluation:
- 50% for the continuous evaluation, of which
- 30% (15% each) for the two intermediary reports to be produced (developed throughout the practical sessions)
- 20% for the final defence of the developed software system
- 50% for the exam
- A potential bonus or malus up to ±10% on the final score for those students who participated very actively (or not) during the group sessions
In case the score obtained for the exam, or the score obtained for the continuous evaluation would be less than 10/20, then the student’s final score for the course will not be calculated as an average of both scores, but rather as the minimum of the score of the exam and of the continuous evaluation (and will remain therefore below 10/20). It is therefore in the students interest to study the course matter well, and to assist to and participate actively in the practical sessions and group work.
Since the (group) work for the continuous evaluation can only be carried out during the semester, the score for this part of the course will be kept for the september session in case of a second session. There will, however, be a new exam in September. In second session, the rule for calculating the final score for this course will remain the same as for the June session: the final score will be equal to the average of the exam score and the score for the continuous evaluation, unless if the score for either the exam or for the continuous evaluation is less than 10/20, in which the final score will be calculated as the minimum of both values. Only the bonus or malus given in first session, will no longer be applied in second session.
This implies that, if someone was absent for the practical sessions and therefore for the project, he or she will have a 0 for the project and therefore a 0 for the entire course, even in September, since the continuous evaluation part of the course cannot be done again during the summer recess.
- Bases de données, Jean-Luc Hainaut, Dunod.
- Information Modeling and Relational Databases, Terry Halpin, Morgan Kaufmann.
- UML Distilled, Martin Fowler, Addison-Wesley.
Les transparents des cours magistraux, les énoncés des travaux pratiques, ainsi que d'autres informations pratiques relatives au cours seront accessibles en ligne (cf. ressources en ligne). Le même plate-forme en ligne sera également le moyen de communication préféré entre les étudiants et l'équipe didactique.
The course slides, instructions for the practical sessions, as well as any other relevant and practical information related to the course will be accessible on-line (see on-line resources). The same platform will also be the preferred means of communication between the teacher(s) and the students.