DATA PROGRAMMING

The course offers the basic tools for managing data. These skills will be used in the following courses. both in the statistics and in the management areas.

At the end of the course the student should be able to design and use a relational database, addressing typical Public Administration scenarios.

As a prerequisite, the student should be equipped by some basics computer science notions and by logic and mathematical abstraction skills.

Basic functionalities of Data Base Management Systems
Data Models
The Relational Model
The Entity Relationship Model
Data Base Design
Query Design using SQL
Normal Forms
Security Issues in Data Base Management
Applications in data management within PA

Fundamental of Database Systems - 7°ed
Ramez Elmasri e Shamkant B. Navathe
Prentice Hall, 2016

The exam is aimed at evaluating the acquisition of basic and methodological knowledge for the design and creation of a database, and the actual ability to apply them to a case study.
It is expressed in a written test, containing a series of exercises of similar difficulty, aimed at verifying both some basic technical knowledge and the ability to develop solutions to real problems.
Each exercise is assigned a rating (based on the correctness and completeness of the answer) and the final grade is obtained as the sum of the ratings of the individual questions.

The teaching will be supported by powerpoint slides, that will be discussed with students in class.
Weekly assignments will be given to be solved individually.

Italian

written

This subject deals with topics related to the macro-area "Cities, infrastructure and social capital" and contributes to the achievement of one or more goals of U. N. Agenda for Sustainable Development