The course aims at teaching the basis of the design and management of the structured information contained in databases.
The course covers all the classical topics related to databases and database management systems (DBMS), starting from the general concepts of information and data, the conceptual design, to the specifics of a relational database management system (MySQL), normalisation and Relational Algebra. From a more practical perspectives, it presents the theory and practice of database design and implementation through a case study.
The course takes a practical approach, aimed at teaching the fundamentals of DBMS and data base design using a large set of examples and applications. As part of this, a database design project based on MySQL will be assigned to students in order to expose them to realistic database applications.
Students knowledge will be tested using 3 theoretical and 1 practical tests during the semester (no final exam).
Required: Fundamentals of Database Systems (6nd edition) by Emasri and Navathe, Addison-Welsey, 2010 (or later editions).