Course Details for A.Y. 2010/2011
Name:
Basi di Dati / Databases
Basic information
Language:
Italian
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.
Course page updates
This course page is available (with possible updates) also for the following academic years:
To read the current information on this course, if it is still available, go to the university course catalogue .
Course information last updated on: 19 maggio 2010, 11:09