Dettagli sull'Insegnamento per l'A.A. 2018/2019

Obiettivi

This course aims at providing practical knowledge and competences about database systems. After a brief introduction to database systems and their architectures, the course turns to data modelling through the Entity-Relationship model. Then, a brief overview of the Boolean algebra is provided, in order to introduce students to SQL essential aspects. The latter consist of introducing data types and definition, and training students on basic SQL constraints and queries, as well as insert/delete/update operations. Afterwards, SQL advanced aspects are provided, such as complex queries, triggers, views and modification of a database schema. Finally, the course introduces database programming, illustrates limitations of traditional database systems and provides knowledge about XML and JSON data formats.

Sillabo

• Introduction to database systems and architectures.
• Usage of the Entity Relationship model for data modelling.
• Boolean Algebra.
• SQL essential aspects: data types and data definition, basic SQL constraints and querying, insert/delete/update.
• SQL advanced aspects: complex queries, triggers, views, database schema modification.
• Introduction to database programming and advanced aspects: limitations, XML and JSON data formats.

Testi di riferimento

• Elmasri Ramez And Navathe Shamkant, Fundamentals of Database Systems , Pearson. (vol. 7th edition) 2016.    

Modalità d'esame

The exam of the Database Systems course is composed of a mandatory written test and an optional oral test. The oral test can be required: by the student in order to improve grades; by the teacher in case the student's written test has serious omissions or mistakes.

Aggiornamenti alla pagina del corso

• A.A. 2017/2018
• A.A. 2018/2019
• A.A. 2019/2020