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 presence

Modalità 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.

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 presence

Modalità 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.

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 presence

Modalità 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.

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 presence

Modalità 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.