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.
Curriculum
scheda docente
materiale didattico
Relational Model - Textbook, Chapter 2 (entire)
Relational Algebra - Textbook, Chapter 3 (excluding sections 3.2 and 3.3)
SQL - Textbook, Chapters 4 (excluding sections 4.2.1, 4.2.4, 4.2.5, 4.2.9) and 5 (excluding sections 5.1.2, 5.1.6, 5.2, 5.3, 5.4)
E-R Model - Textbook, Chapter 6 (excluding section 6.4)
Conceptual Design - Textbook, Chapter 7 (excluding section 7.7)
Logical Design - Textbook, Chapter 8 (excluding section 8.6)
Normalization - Textbook, Chapter 9 (excluding sections 9.4.2, 9.4.3, 9.5, and 9.6)
Fruizione: 20801686 BASI DI DATI in Ingegneria Informatica e dell'Intelligenza Artificiale L-8 R MERIALDO PAOLO, ATZENI PAOLO
Programma
Database Basics: Fundamental Properties - Textbook, Chapter 1 (entire)Relational Model - Textbook, Chapter 2 (entire)
Relational Algebra - Textbook, Chapter 3 (excluding sections 3.2 and 3.3)
SQL - Textbook, Chapters 4 (excluding sections 4.2.1, 4.2.4, 4.2.5, 4.2.9) and 5 (excluding sections 5.1.2, 5.1.6, 5.2, 5.3, 5.4)
E-R Model - Textbook, Chapter 6 (excluding section 6.4)
Conceptual Design - Textbook, Chapter 7 (excluding section 7.7)
Logical Design - Textbook, Chapter 8 (excluding section 8.6)
Normalization - Textbook, Chapter 9 (excluding sections 9.4.2, 9.4.3, 9.5, and 9.6)
Testi Adottati
P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone: Database Systems - Concepts, Languages and Architectures, The McGraw-Hill Companies, 1999.Modalità Frequenza
In presenceModalità Valutazione
The practical exam consists of writing SQL queries and takes place in the laboratory, on the Moodle platform. During the course, the student can participate in three interim tests. The student who successfully passes all three tests will not have to take the final exam: the final grade corresponds to the average of the grades obtained in the three tests.
scheda docente
materiale didattico
Fruizione: 20801686 BASI DI DATI in Ingegneria Informatica e dell'Intelligenza Artificiale L-8 R MERIALDO PAOLO, ATZENI PAOLO
scheda docente
materiale didattico
Relational Model - Textbook, Chapter 2 (entire)
Relational Algebra - Textbook, Chapter 3 (excluding sections 3.2 and 3.3)
SQL - Textbook, Chapters 4 (excluding sections 4.2.1, 4.2.4, 4.2.5, 4.2.9) and 5 (excluding sections 5.1.2, 5.1.6, 5.2, 5.3, 5.4)
E-R Model - Textbook, Chapter 6 (excluding section 6.4)
Conceptual Design - Textbook, Chapter 7 (excluding section 7.7)
Logical Design - Textbook, Chapter 8 (excluding section 8.6)
Normalization - Textbook, Chapter 9 (excluding sections 9.4.2, 9.4.3, 9.5, and 9.6)
Fruizione: 20801686 BASI DI DATI in Ingegneria Informatica e dell'Intelligenza Artificiale L-8 R MERIALDO PAOLO, ATZENI PAOLO
Programma
Database Basics: Fundamental Properties - Textbook, Chapter 1 (entire)Relational Model - Textbook, Chapter 2 (entire)
Relational Algebra - Textbook, Chapter 3 (excluding sections 3.2 and 3.3)
SQL - Textbook, Chapters 4 (excluding sections 4.2.1, 4.2.4, 4.2.5, 4.2.9) and 5 (excluding sections 5.1.2, 5.1.6, 5.2, 5.3, 5.4)
E-R Model - Textbook, Chapter 6 (excluding section 6.4)
Conceptual Design - Textbook, Chapter 7 (excluding section 7.7)
Logical Design - Textbook, Chapter 8 (excluding section 8.6)
Normalization - Textbook, Chapter 9 (excluding sections 9.4.2, 9.4.3, 9.5, and 9.6)
Testi Adottati
P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone: Database Systems - Concepts, Languages and Architectures, The McGraw-Hill Companies, 1999.Modalità Frequenza
In presenceModalità Valutazione
The practical exam consists of writing SQL queries and takes place in the laboratory, on the Moodle platform. During the course, the student can participate in three interim tests. The student who successfully passes all three tests will not have to take the final exam: the final grade corresponds to the average of the grades obtained in the three tests.
scheda docente
materiale didattico
Fruizione: 20801686 BASI DI DATI in Ingegneria Informatica e dell'Intelligenza Artificiale L-8 R MERIALDO PAOLO, ATZENI PAOLO