DATA PROGRAMMING

Academic year
2020/2021 Syllabus of previous years
Official course title
DATA PROGRAMMING
Course code
EM1102 (AF:331112 AR:176826)
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 and formalizing processes. 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 dabtabase, as well as to formalize processes using BPMN notation.

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
Relational Algebra
The Entity Relationship Model
Data Base Design
Query Design using SQL
Normal Forms
Security Issues in Data Base Management
Formalizing processes in BPMN
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 "Cities, infrastructure and social capital" and contributes to the achievement of one or more goals of U. N. Agenda for Sustainable Development

Definitive programme.
Last update of the programme: 22/04/2020