DATA PROGRAMMING

Academic year
2023/2024 Syllabus of previous years
Official course title
DATA PROGRAMMING
Course code
EM1102 (AF:449464 AR:255338)
Modality
On campus classes
ECTS credits
6
Degree level
Master's Degree Programme (DM270)
Educational sector code
INF/01
Period
1st Term
Course year
1
Where
VENEZIA
Moodle
Go to Moodle page
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 final exam will consist on about five to ten exercises, aimed at checking basic knowledge and skills on the design and querying of a relational database, and the ability of using them for addressing real problems.
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 "Circular economy, innovation, work" and contributes to the achievement of one or more goals of U. N. Agenda for Sustainable Development

Definitive programme.
Last update of the programme: 17/03/2023