20810227 - DATABASES

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

teacher profile | teaching materials

Fruizione: 20801758 BASI DI DATI I in Ingegneria informatica L-8 N0 ATZENI PAOLO

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

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) are available on the course Web site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/compitiPDF/index.html During the COVID-19 emergency, the exam could be held in an oral way, possibly preceded by written exercises. For each student, the whole exam is held in one day.

teacher profile | teaching materials

Fruizione: 20801758 BASI DI DATI I in Ingegneria informatica L-8 N0 ATZENI PAOLO

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

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) are available on the course Web site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/compitiPDF/index.html During the COVID-19 emergency, the exam could be held in an oral way, possibly preceded by written exercises. For each student, the whole exam is held in one day.

teacher profile | teaching materials

Fruizione: 20801758 BASI DI DATI I in Ingegneria informatica L-8 N0 ATZENI PAOLO

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

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) are available on the course Web site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/compitiPDF/index.html During the COVID-19 emergency, the exam could be held in an oral way, possibly preceded by written exercises. For each student, the whole exam is held in one day.

teacher profile | teaching materials

Fruizione: 20801758 BASI DI DATI I in Ingegneria informatica L-8 N0 ATZENI PAOLO

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

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) are available on the course Web site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/compitiPDF/index.html During the COVID-19 emergency, the exam could be held in an oral way, possibly preceded by written exercises. For each student, the whole exam is held in one day.