Databases - Teoria (2008/2009)

Course Not running, not visible

Course code
4S00037
Name of lecturer
Barbara Oliboni
Number of ECTS credits allocated
6
Academic sector
INF/01 - INFORMATICS
Language of instruction
Italian
Location
VERONA
Period
2° Q dal Jan 26, 2009 al Mar 27, 2009.

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

Lesson timetable

Learning outcomes

This unit introduces issues related to the design of a databases by considering both logical data models and conceptual data models.
Moreover, the unit introduces the SQL query language.

Syllabus

* Introduction to the database management systems

* Logical design of a database
-- The relational data model

* Relational algebra

* SQL

* Conceptual design of a database
-- The Entity-Relationship data model
-- From conceptual schemata to relational schemata

* DBMS Architectures

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

--

Teaching aids

Documents

Share