Please use this identifier to cite or link to this item: http://hdl.handle.net/10609/131807
|Diseño e implementación de la base de datos para una aplicación de gestión de procesos electorales
|Martínez del Amo, Francisco José
|Ferrer Durán, Jordi
|Universitat Oberta de Catalunya (UOC)
|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.
|Appears in Collections:
|Treballs finals de carrera, treballs de recerca, etc.
Files in This Item:
|Producto Base de Datos
|Presentación del TFG
|Memoria del TFG