Learning outcomes

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.

Content

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.

Assessment method

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 evaluation consists of a 3-hour long written exam (quadrimester 1), and a group project (quadrimester 2).

Sources, references and any support material

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.)

Language of instruction

French