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)

Core Documentation

P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone: Database Systems - Concepts, Languages and Architectures, The McGraw-Hill Companies, 1999.

Attendance

In presence

Type 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.

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)

Core Documentation

P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone: Database Systems - Concepts, Languages and Architectures, The McGraw-Hill Companies, 1999.

Attendance

In presence

Type 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.

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)

Core Documentation

P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone: Database Systems - Concepts, Languages and Architectures, The McGraw-Hill Companies, 1999.

Attendance

In presence

Type 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.

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)

Core Documentation

P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone: Database Systems - Concepts, Languages and Architectures, The McGraw-Hill Companies, 1999.

Attendance

In presence

Type 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.