Building a database system for mobile-based voting problem using MYSQL database management system

Abstract

The database system is a key factor enabling software to operate efficiently, securely, and safely. This article surveys solutions for designing a database for the voting problem on mobile platforms, comparing the characteristics of popular database management systems such as Microsoft SQL Server, Oracle Database, PostgreSQL, and MySQL. It then implements a database system for the voting problem using MySQL, providing solutions involving several Views (virtual tables), Procedures, Indexes, and Triggers in MySQL to ensure the system meets requirements for performance, security, data integrity, and addresses challenges in query optimization, especially in an online voting environment.