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, aimed at verifying both some basic technical knowledge and the ability to develop solutions to real problems.
Each exercise is assigned a score. The sum of the points assigned to the exercises is greater than 30. Each exercise done by the student is rated based on the correctness and completeness of the answer.
Regarding final grading, scores in the 18-22 range will be awarded for: sufficient knowledge and applied comprehension of the program, limited ability to collect and/or interpret data, formulating independent judgments, and sufficient communication skills, especially regarding the use of IT terminology.
Scores in the 23-26 range will be awarded for: fair knowledge and applied comprehension of the program; fair ability to collect and/or interpret data, formulating independent judgments; fair communication skills, especially regarding the use of certain IT terminology.
Scores in the 27-30 range will be awarded for good or excellent knowledge and applied comprehension of the program; good or excellent ability to collect and/or interpret texts, formulating independent judgments; and fully appropriate communication skills, especially regarding the use of correct IT terminology.
Honors will be awarded for excellent knowledge and skills, applied understanding of the program, judgment, and communication skills.

written

points are assigned to each of the exercises in the final exam (for a total of 33 points). The final grade will correspond to the sum of the points obtained for the questions with a satisfactory answer.

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