Course Details

Name:

Basi di Dati / Databases

Type:

Module

Main course:

Basi di Dati con Laboratorio / Data Bases with Lab

The course profile, written following the Tuning international methodology, is available here.

Basic information

Code:

F0137

Sector:

INF/01

Credits:

Bachelor Degree in Computer Science: 6 Ects (b)

Term:

2^nd semester

Degree(s):

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

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.

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.

Teaching Methods

Language: Italian
Lectures and interactive exercise sessions.

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.

Notes

Orario di ricevimento: Mercoledi' 10:30-12:30 oppure su appuntamento email (the lecturer can meet the students on Wednesday, 10:30-12:30 or by making an appointment via email) Curriculum Vitae docente (Lecturer CV): http://www.di.univaq.it/stefcost/curring.htm NOTA: per sillabo, testi ecc. vedi Basi di Dati con Laboratorio

Online Teaching Resources

Homepage:

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

Teaching material:

Click here to access the teaching material available on this site (last update: 01/06/2017).

Recent teaching material

This list contains only the latest published resources. Resources marked with an asterisk belong to other courses (indicated between brackets)

Click here to access the complete resources list.

Course page updates

This course page is available (with possible updates) also for the following academic years:

Course information last updated on: 25 gennaio 2018, 13:04