Databases (2011/2012)

Course code
4S00037
Name of lecturer
Carlo Combi
Coordinator
Carlo Combi
Number of ECTS credits allocated
6
Academic sector
INF/01 - INFORMATICS
Language of instruction
Italian
Location
VERONA
Period
II semestre dal Mar 1, 2012 al Jun 15, 2012.

Lesson timetable

II semestre
Day Time Type Place Note
Tuesday 4:30 PM - 6:30 PM lesson Lecture Hall G  
Thursday 8:30 AM - 10:30 AM lesson Lecture Hall G  

Learning outcomes

This course provides the student with the main theoretical concepts of the relational data model, of object and object-relational data models, and of the semistructured and XML data models. Related query languages will be introduced and some related technical issues will be discussed.

Syllabus

The relational data model: relational calculus, functional dependencies, normal forms and decompositions.

Temporal databases: basic concepts, data models, query languages, and technological issues.

Object and object-relational databases: data models and query languages.

Semistructured databases: basic concepts, XML, XML Schema, DTD, XPath, and Xquery.

Assessment methods and criteria

The final exam is an oral examination, with questions and exercises on the considered topics.