At the end of the course, the (motivated) student will have acquired a good practical and theoretical knowledge of database concepts, SQL language, database implementation techniques and database design methodologies. The student will be able to build in a systematic way a good quality database and to evaluate the quality and weaknesses of an existing database.
PART 1 - Concepts Concepts of relational databases. SQL language (SQL2 and SQL3). PART 2 - Technology Data structures implementation. Database Management Systems. PART 3 - Methodology Database methodology. The relational model and normalisation. The Entity-relationship model and UML class diagrams. Conceptual analysis of the aplication domain. Logical design of a relational (and relational-object) database. Physical design of a relational database. Database reverse engineering.
Three aspects are evaluated: theoretical and technical knowledge, ability to combine knowledge from various parts of the course and the capacity to solve practical problems. There are two examination sessions (quadrimester 1 and 2), each 3 hour long and comprising 10 to 15 questions. Books and personal notes not allowed.
Hainaut, J.-L., Bases de données - Concepts, utilisation et développement, Coll. Sciences Sup, Dunod, Paris, 2012 (in French)
Date, C., J., An Introduction to Database Systems, Addison-Wesley, 2004 (1024 p.)
Garcia-Molina, H., Ullman, J., D., Widom, J., Database Systems - The complete Book, Prentice-Hall, 2008 (1248 p.)
| Training | Study programme | Block | Credits | Mandatory |
|---|---|---|---|---|
| Bachelier en sciences informatiques | Standard | 0 | 3 | |
| Bachelier en sciences mathématiques | Standard | 0 | 5 | |
| Bachelier en sciences informatiques | Standard | 2 | 3 |