Databases and WEB - Teoria: basi di dati (2004/2005)-Dep.Computer Science-University of Verona

Follow on

Course Not running, not visible

Course code

4S00012

Name of lecturer

Alberto Belussi

Number of ECTS credits allocated

6

Other available courses

Language of instruction

Italian

Location

VERONA

Period

Second four-month term, Third four-month term

Course news Seminars related to the course

To show the organization of the course that includes this module, follow this link Course organization

Lesson timetable

Learning outcomes

The module "Teoria: basi di dati" (Database Theory) of the course “Databases and WEB” aims to provide the notions that are necessary for the design and implementation of a database on the current tecnologies.

Syllabus

* Introduction to database systems: architecture and functionalities of a database management system (DBMS). Phisical independence, logical independence, concurrency, durability, reliability, query and update. Advantages of a DBMS with respect to a File System.
* Conceptual design of a database: the Entity-Relationship model (E-R model). Constructs of the E-R model: entity, attribute, relationship, hierarchy and cardinality constraints. Conceptual database schema.
* Logical database design: data models of database systems. The relational model: relations, integrity constraints and relational schema. Mapping rules from E-R schemas to
relational schemas. Data definition languages for relational databases: the SQL language.
* Interaction with a relational database: the relational algebra and SQL. SQL: SELECT-FROM-WHERE clauses, join, tuple variables, nested queries, order by and group by clauses, insert, delete and update commands. Views.
* The internal achitecture of a DBMS. Transaction. Transaction properties.
Concurrency control: two phase locking, view and conflict serializability. Access methods: primary and secondary indeces. B-trees and hashing.

Reference books
Author	Title	Publisher	Year	ISBN	Note
P. Atzeni, S. Ceri, P. Fraternali, S. Paraboschi, R. Torlone	Basi di dati. Architetture e linee di evoluzione	McGraw-Hill	2003	88-386-603
P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone	Basi di dati, modelli e linguaggi di interrogazione	McGraw-Hill	2002	8838660085
E. Baralis, A. Belussi, G. Psaila	Basi di dati - Temi d'esame svolti (Edizione 1)	Progetto Leonardo Società Editrice Esculapio Bologna	1999	B135655713

Assessment methods and criteria

The exams of the modules "Teoria: basi di dati" (Database theory), "Teoria: siti web centrati sui dati" (Data intensive Web applications) and "Laboratorio" (Workshop) are organized as a unique test. The exam is oral.
In order to access the oral examination, the student has to exceed a written test of about 3 hours concerning the design of a database, the design of a data intensive web application and the specification of queries in SQL and relational algebra. Moreover, some questions about internal DBMS architecture and general concepts can be included in the test.