The general objective of this course is to learn how to manipulate and model information using the relational database approach. At the end of the course, the student should be able to: - Understand and use relational database concepts - Model a relational database - Formulate a query in relational algebra and SQL - Apply relational concepts in dataoriented applications
The course focuses on relational databases. The approach of this course is based on theory combined with exercises. It is divided into 3 parts: - Concepts (the data model, normalisation) - Data manipulation (via relational algebra, SQL2 and SQL3) - Methodology (model, conceptual analysis, logical design)
Final exam (100%) which will consist of two parts: - Theoretical part: duration 2h (50%) - Practical part: duration 2h (50%)
J-L Hainaut, Bases de données - Concepts, utilisation et développement, Dunod, 2009.