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, to the specifics of a relational database management system, with SQL and QBE. It also deals with the the methodology for database design, both from a theoretical and practical perspective. No programming experience is required, but a basic understanding of data structures and algorithms.
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 course (no final exam).
- Required: Fundamentals of Database Systems (6nd edition) by Emasri and Navathe, Addison-Welsey, 2010 (or later editions).