20801686 - DATABASES

MERIALDO PAOLO

Mutuazione: 20801686 BASI DI DATI in Ingegneria Informatica e dell'Intelligenza Artificiale L-8 R MERIALDO PAOLO, ATZENI PAOLO

ATZENI PAOLO

Mutuazione: 20801686 BASI DI DATI in Ingegneria Informatica e dell'Intelligenza Artificiale L-8 R MERIALDO PAOLO, ATZENI PAOLO

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.

Risultati Apprendimento Attesi

relational database design
SQL

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

Bibliografia Di Riferimento

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.