Course Details for A.Y. 2010/2011

Course Objectives

Following this course, the students should: understand what is a database, from the conceptual, mathematical and practical point of view. Become able to develop the conceptual and logical design of a relational database, including both the structure and the operations. Understand the basic

Course Content

• Introduction, data models, the relational model (RL).
• Relational algebra and calculus, Datalog.
• Normalization of relational schemata.
• Database Conceptual Design: Entity Relationship (E-R) diagrams.
• Database Logical Design: restructuring E-R diagrams and translating them into RL.
• Introduction to Database Technology: concurrency and fault-tolerance.

Prerequisites and Learning Activities

The student should be acquainted with some programming language, so as to understand what a file is, and to have experimented some basic operations on files. The student should possess some basic knowledge of operating systems, namely about the file-system and convurrency.

Assessment Methods and Criteria

Chi ha acquisito la frequenza negli anni precedenti al 2007/08 dovrà sostenere l'esame del corso di Basi di Dati. Gli studenti immaatricolati nell'A.A. 2007/08 dovranno sostenere l'esame unico di Basi di Dati con Laboratorio.

Textbooks

• Atzeni, Ceri, Paraboschi, Torlone, Basi di Dati: Concetti, Linguaggi e Architetture, , 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