Course Details for A.Y. 2013/2014

Course Objectives

Following this course, the students will integrate and complete their knowledge of the formal models used in the database design process (entity-relationship, relational, etc), viewing them applied to real case studies. They will learn how to interact with the most common DBMS systems through the SQL language and the interfaces supplied by the programming languages. Finally, the students will be involved in the entire development process of a complete database, starting from the stakeholder's specifications and going through the conceptual and logical design phases to the implementation of the requested functionalities and of the user interface.

Course Content

• Requisite analysis and conceptual database design
• Logical database disign
• Data definition in SQL. Integrity constraints
• Data insertion, modification and deletion with SQL
• Base SQL queries. Advanced queries: subqueries, inner and outer join between tables, results grouping and ordering, union queries.
• Advanced SQL concepts: views, procedures, triggers. SQL and programming languages

Prerequisites and Learning Activities

The course requires some basic programming skills (variables and data types, functions, iteration constructs, conditional statements, etc.)

Assessment Methods and Criteria

The course final project requires the development of a complete, working database from a specification given during the course. The project can be carried out individually or in small workgroups.

Textbooks

• Atzeni, Ceri, Fraternali, Paraboschi, Torlone, Basi di dati - Modelli e linguaggi di interrogazione , McGraw-Hill.    

Internet Resources

Course page updates

• A.Y. 2010/2011
• A.Y. 2011/2012
• A.Y. 2012/2013
• A.Y. 2013/2014
• A.Y. 2014/2015
• A.Y. 2015/2016
• A.Y. 2016/2017
• A.Y. 2017/2018
• A.Y. 2018/2019
• A.Y. 2019/2020