Guia docente 2023_24 Facultade de Dirección e Xestión Pública

Grado en Dirección y Gestión Pública

Data Management in Public Administrations

Contents

Topic	Sub-topic
Subject 1- Applications and use of the software	- Types of commercial and free Software - Types of office packages - Licences and types of licences - Software of packages and his relation and use
Subject 2- Information systems	-Data support -Formats and exchange of information -Transaction of data
Subject 3- Databases	-Definition of database -Types of databases -Normal forms basic and applied -Logical and physical design of a DB -Types of keys (primary, secondary...) -Types of data of the fields -Object Oriented Data Bases -Persistence and security
Subject 4- Dababase Management Systems	-Database Management Systems (DBMS) -Ranking and main differences -Use of the DBMS -Handle a DBMs in a Public Administration -Data persistence
Subject 5- Handle of tables	-Creation of databases: tables and relations among them -Application of the normal forms -Keys election: primary and secondary...) -Levels of connection of tables -Manipulation of data (insertion, erase and modification) -Look for information stored
Subject 6- Transfer of data	-Description of a data net -Internet, IP address and protocol types -Net elements and topologies -Public and personal Nets, proxy -Nets Interconnection: wired and wireless systems -Internet services (email, web, FTPs, browsers, telnet, searcher, etc.) -Basic control and security -Chats, messages and videoconference
Subject 7- Security	-Basic bases -Ranking of the security: physical-logical, active-passive -The security and the protection of data in the computers and in the nets -Cryptography, digital certification, electronic signature and electronic identity card