At the end of the course, the (motivated) student will have acquired a good practical and theoretical knowledge of database concepts, SQL language 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.
The first part of the lecture describes practical elements of the relational theory, including topics such as relational algebra, functional dependencies, inclusion constraints and normalization.
The next parts study the principles of database design. They describe the standard database life cycle, Entity-relationship and UML conceptual models, as well as logical and physical models for SQL2. The lecture develops the main engineering processes : conceptual analysis, logical design, physical design and coding.
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. The written examination is 3 hour long. 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.)