Course Details for A.Y. 2014/2015

The information on this page refer to the academic year 2014/2015. Therefore, several links are not available and data may be incomplete. To read the current information on the course, if it is still available, go to the university course catalogue . To read information relating other academic years, use the list at the bottom of this page.

A. Year:

2014/2015

Name:

Basi di Dati / Databases

Type:

Module

Main course:

Basi di Dati con Laboratorio / Data Bases with Lab

Basic information

Code:

F1I015

Sector:

INF/01

Credits:

: Bachelor Degree in Computer Science 6 CFU (b)

Term:

2^nd semester

Degree(s):

Bachelor Degree in Computer Science 2^nd anno curriculum General Compulsory

Language:

Italian

Teacher(s):

Stefania Costantini

Same as:

Basi di Dati

Course Objectives

Following this course, the students will: understand what is a database, from the conceptual, mathematical and practical points 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 functionalities of a DBMS (Data Base Management System); acquire notions about advanced aspects and future directions of the filed.

Course Content

Introduction, data models, the relational model (RL).
Relational algebra and calculus, Datalog.
Database Conceptual and Logical Design: Entity Relationship (E-R) diagrams, restructuration and translation into relational schemas.
Normalization of relational schemas.
Advanced databases: object-oriented databases, hints on data wharehouses and cloud-computing.
Database Technology: concurrency and fault-tolerance.

Learning Outcomes (Dublin Descriptors)

On successful completion of this course, the student should

Acquiring knowledge and understanding about data models, database technology and future developments of the field.
Applying knowledge and understanding to designing and querying data-centric systems.
Making informed judments and choices about techniques and toos to exploit in practical applications.
Communicating knowledge an understanding about importance, applications and perspective of data-centric systems.
Capacities to continue learning on future developments and perspective applications of the field.

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 concurrency. It is mandatory to possess basic notions of mathematical Logic and Set Theory.

Assessment Methods and Criteria

The exam of the Database Module is composed of a mandatory written test and an optional oral test. The oral test can be required: by the student in order to improve grades; by the teacher in case the student's written test has serious omissions or mistakes.

Textbooks

Atzeni, Ceri, Paraboschi, Torlone, Basi di Dati: Concetti, Linguaggi e Architetture, , McGraw-Hill.

Internet Resources

Homepage:

http://www.di.univaq.it/stefcost/

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: 26 ottobre 2014, 12:36