20801686 - DATABASES

Obiettivi

Presentation of models, methods and tools for the definition, design and development of software systems that manage large sets of data. A student who has passed the course will be able to: (i) develop software applications that make use of databases of even high complexity, (i) design and built autonomously databases of medium complexity, and (iii) be involved in the project and development of large databases of high complexity.

Programma

Relational model
Relational Algebra
SQL
Database design
Conceptual design
Logical design
Normalization

Prerequisiti

None

Testi Adottati

Atzeni, Ceri, Fraternali, Paraboschi, Torlone: Databases. McGraw-Hill

Modalità Frequenza

Suggested

Modalità Valutazione

Multiple choice questions SQL queries Conceptual design Logical design Normalization

Esempi Domande

On the course website, the texts of all past exams are available.