Please use this identifier to cite or link to this item: http://hdl.handle.net/10609/131807
Title: Diseño e implementación de la base de datos para una aplicación de gestión de procesos electorales
Author: Martínez del Amo, Francisco José
Tutor: Ferrer Durán, Jordi
Others: Baró, Xavier  
Keywords: elections
electronic voting
politics
Issue Date: 10-Jun-2021
Publisher: Universitat Oberta de Catalunya (UOC)
Abstract: The purpose of this work is the design of a database system that controls the different electoral processes, both at the national and local levels, maximizing their efficiency and transparency. Furthermore, this system is intended to allow and facilitate the progressive implementation of electronic or telematic voting in current electoral processes. In this way, the system manages the electoral registration, the communications, the participating political parties involved and their candidates, the electoral districts, the voting centers next to the polling stations, the voting process, as well as the vote counting, election results and relevant statistical information. An iterative methodology is applied, which allows the final product to be refined in such a way to avoid, that the discovery of a poor definition in the requirements or an error in the logical or conceptual design at any point, could delay the execution of the project. The required consultations for the adequate management and analysis of the data of each electoral process have been carried out using SQL and PL-SQL language with an Oracle 11 DBMS, using scripts, indexes, triggers and stored procedures and a set of proof tests that allow its correct verification. Data management is carried out with Data Wharehouse techniques, taking into account that statistical queries are carried out optimizing its operation/performance/functioning for obtaining efficient response times.
Language: Spanish
URI: http://hdl.handle.net/10609/131807
Appears in Collections:Treballs finals de carrera, treballs de recerca, etc.

Files in This Item:
File Description SizeFormat 
fmartinez59TFG0621producto.zipProducto Base de Datos4,97 MBUnknownView/Open

fmartinez59TFG0621presentación.mp4

Presentación del TFG335,32 MBMP4View/Open
fmartinez59TFG0621memoria.pdfMemoria del TFG3,03 MBAdobe PDFThumbnail
View/Open