Programme

Database systems: general properties. Relational model. Relational algebra. SQL. Conceptual database design. Logical database design. Normalization-

Core Documentation

P. Atzeni et al. Basi di dati 5/Ed. McGraw-Hill, 2018 (in alternative, any major database textbook, contact the instructor for advice)
Additional material available on the course site:
http://www.dia.uniroma3.it/~atzeni/didattica/BDN/BDNindex.html

Type of delivery of the course

Class lectures, class exercises, practical activities (small projects), to be developed along lines provided by the instructor. Should the COVID-19 emergency continue, the course will implement all the indications provided by the university. If needed video-lectures will be broadcast and recorded, with the appropriate modes of interaction with students, on site or remote.

Attendance

Not compulsary

Type of evaluation

The written examination contains 3-6 exercises, aimed at verifying the level of effective comprehension of the concepts and the ability of the student to apply them in practical contexts. Optional midterms are also offered, with the same structure. All the exam (and midterm) tests of previous years (since 1998) area available on the course Web site: http://www.dia.uniroma3.it/~atzeni/didattica/BDN/compitiPDF/index.html During the COVID-19 emergency: - examinations will be held by appointment - they will be mainly oral, via the online platform, with the discussion of brief exercises, similar to those usually proposed, to be solved during the discussion with the instructor or during a preliminary written test held the same day

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 systems: general properties. Relational model. Relational algebra. SQL. Conceptual database design. Logical database design. Normalization-

Core Documentation

P. Atzeni et al. Basi di dati 5/Ed. McGraw-Hill, 2018 (in alternative, any major database textbook, contact the instructor for advice)
Additional material available on the course site:
http://www.dia.uniroma3.it/~atzeni/didattica/BDN/BDNindex.html

Type of delivery of the course

Class lectures, class exercises, practical activities (small projects), to be developed along lines provided by the instructor. Should the COVID-19 emergency continue, the course will implement all the indications provided by the university. If needed video-lectures will be broadcast and recorded, with the appropriate modes of interaction with students, on site or remote.

Attendance

Not compulsary

Type of evaluation

The written examination contains 3-6 exercises, aimed at verifying the level of effective comprehension of the concepts and the ability of the student to apply them in practical contexts. Optional midterms are also offered, with the same structure. All the exam (and midterm) tests of previous years (since 1998) area available on the course Web site: http://www.dia.uniroma3.it/~atzeni/didattica/BDN/compitiPDF/index.html During the COVID-19 emergency: - examinations will be held by appointment - they will be mainly oral, via the online platform, with the discussion of brief exercises, similar to those usually proposed, to be solved during the discussion with the instructor or during a preliminary written test held the same day

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 systems: general properties. Relational model. Relational algebra. SQL. Conceptual database design. Logical database design. Normalization-

Core Documentation

P. Atzeni et al. Basi di dati 5/Ed. McGraw-Hill, 2018 (in alternative, any major database textbook, contact the instructor for advice)
Additional material available on the course site:
http://www.dia.uniroma3.it/~atzeni/didattica/BDN/BDNindex.html

Type of delivery of the course

Class lectures, class exercises, practical activities (small projects), to be developed along lines provided by the instructor. Should the COVID-19 emergency continue, the course will implement all the indications provided by the university. If needed video-lectures will be broadcast and recorded, with the appropriate modes of interaction with students, on site or remote.

Attendance

Not compulsary

Type of evaluation

The written examination contains 3-6 exercises, aimed at verifying the level of effective comprehension of the concepts and the ability of the student to apply them in practical contexts. Optional midterms are also offered, with the same structure. All the exam (and midterm) tests of previous years (since 1998) area available on the course Web site: http://www.dia.uniroma3.it/~atzeni/didattica/BDN/compitiPDF/index.html During the COVID-19 emergency: - examinations will be held by appointment - they will be mainly oral, via the online platform, with the discussion of brief exercises, similar to those usually proposed, to be solved during the discussion with the instructor or during a preliminary written test held the same day

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 systems: general properties. Relational model. Relational algebra. SQL. Conceptual database design. Logical database design. Normalization-

Core Documentation

P. Atzeni et al. Basi di dati 5/Ed. McGraw-Hill, 2018 (in alternative, any major database textbook, contact the instructor for advice)
Additional material available on the course site:
http://www.dia.uniroma3.it/~atzeni/didattica/BDN/BDNindex.html

Type of delivery of the course

Class lectures, class exercises, practical activities (small projects), to be developed along lines provided by the instructor. Should the COVID-19 emergency continue, the course will implement all the indications provided by the university. If needed video-lectures will be broadcast and recorded, with the appropriate modes of interaction with students, on site or remote.

Attendance

Not compulsary

Type of evaluation

The written examination contains 3-6 exercises, aimed at verifying the level of effective comprehension of the concepts and the ability of the student to apply them in practical contexts. Optional midterms are also offered, with the same structure. All the exam (and midterm) tests of previous years (since 1998) area available on the course Web site: http://www.dia.uniroma3.it/~atzeni/didattica/BDN/compitiPDF/index.html During the COVID-19 emergency: - examinations will be held by appointment - they will be mainly oral, via the online platform, with the discussion of brief exercises, similar to those usually proposed, to be solved during the discussion with the instructor or during a preliminary written test held the same day

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.