MERIALDO PAOLO
Fruizione: 20801686 BASI DI DATI in Ingegneria Informatica e dell'Intelligenza Artificiale L-8 R MERIALDO PAOLO, ATZENI PAOLO
ATZENI PAOLO
Fruizione: 20801686 BASI DI DATI in Ingegneria Informatica e dell'Intelligenza Artificiale L-8 R MERIALDO PAOLO, ATZENI PAOLO
Objectives
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.Programme
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)
Prerequisiti
Fundamentals of computer scienceCore Documentation
P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone: Database Systems - Concepts, Languages and Architectures, The McGraw-Hill Companies, 1999.Reference Bibliography
P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone: Database Systems - Concepts, Languages and Architectures, The McGraw-Hill Companies, 1999.Attendance
In presenceType of evaluation
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.Esempi Domande
See Web site