DBMS MINI[1] - Read-Only for Mini Project

To those who are wondering how to make a DBMS mini project in engineering according VTU scheme.

1. ONLINE VOTING MANAGEMENT SYSTEM USING PHP AND MYSQL By Pavithra H N ( 1VK21AI013 ) & Vruthvik D S (1VK21AI027) (Approved by AICTE, New Delhi & Affiliated to VTU, Belagavi ) Gudimavu , Bangalore-Mysore Road, Kumbalagodu , Kengeri , Bengaluru – 560 074 VIVEKANANDA INSTITUTE OF TECHNOLOGY DATABASE MANAGEMENT SYSTEM MINI-PROJECT Department of Artificial intelligence&Machine Learning

2. Introduction Abstract Methodology E-R Diagram Advantages Conclusion Table of Contents . 2 Department of AIML,VKIT 2023-24

3. 3 Abstract The Online Voting Management System is comprehensive web-based application designed to efficiently manage Voting center , Voting machine ,Citizen candidate and vote. Primary goal is to streamline administrative tasks and reduce manual efforts associated with voting management system. With a user-friendly interface, the system provides the administrator exclusive access to oversee and monitor entire Voting Management System Process. Department of AIML,VKIT 2023-24

4. Introduction Efficient election databases are crucial for ensuring accurate and timely election processes. With PHP and SQL, data can be stored, retrieved, and manipulated seamlessly, reducing errors and improving efficiency. The ability to efficiently manage election databases allows for smooth voter registration, ballot generation, and result tabulation, ultimately enhancing the integrity and transparency of elections. 4 Department of AIML,VKIT 2023-24 In the realm of efficient management of election databases, the dynamic duo of PHP and SQL emerges as a powerful force. P HP (Hypertext Preprocessor) and SQL (Structured QueryLanguage ) are essential tools for efficient management of election-databases . PHP is a server-side scripting language that allows for dynamic web page generation, while SQL is a language for managing relational databases.

5. 5 . Department of AIML,VKIT 2023-24 Understanding the capabilities of PHP and SQL enables election administrators to streamline data storage , retrieval, and manipulation, ensuring accurate and transparent election processes . We will learn how to create polls, implement a voting system, delete polls, and populate the list of published polls. During the poll creation phase, we'll be able to specify as many answers as we want because all answers will be stored in a separate database table. One table will be dedicated to the polls, which we can store poll-related data (title, description, etc ), and the other we'll use to store all the answers, and subsequently associate both tables to populate a list.

6. Methodology 6 Department of AIML,VKIT 2023-24 Before we jump into programming our poll and voting system, there are a few requirements that need to be met. We need to install the development tools and set up the file structure for our app. Form Design  — Design a Poll and Voting app with HTML5 and CSS3. Poll System  — Create a working poll system with PHP & MySQL (create polls, delete polls, and view polls). Voting System  — Each poll will consist of answers that the user can select to cast a vote and subsequently view the result. MySQL Database Interaction  — Interact with a MySQL database using the PHP PDO(data object is a lightweight , consistent framework for accessing database in PHP) interface. All data entered during the creation phase will be stored in the MySQL database.

7. E-R diagram 7 Department of AIML,VKIT 2023-24

8. Department of AIML,VKIT 2023-24 Navigate to your XAMPP (first install XAMPP a web server includes Apache, MySQL, PHP ) htdocs  directory (usually located at  C:\xampp\htdocs ) and create the following files and directories: functi ons.php  — The functions file will contain the template and database connection functions. index.php  — The index page will contain the list of published polls and the navigation buttons. create.php  — The create page will contain form input fields, which we can use to create new polls. vote.php  — The vote page will consist of poll answers with the option to cast a vote. result.php  — The result page will show the results for the specified poll, while each answer will show the number of votes and the percentage bar. style.css  — The stylesheet (CSS3) for our poll and voting system. File Structure and Setup Basic Template System  — We'll create a basic template system for our app, which will consist of header and footer functions. Those functions can then be implemented on all the pages we create. It's so we don't have to write the same code over and over.

9. Advantages 9 Easy to use CRUD operations for login and Citizen Management. It reduces and simplifies the work of the authorities significantly, as they do not have to manually count the votes or print the ballots. It ensures the security and accuracy of the voting process, as the votes are stored in a MySQL database and can be verified using the PHP PDO interface. It provides fast and reliable feedback, as the results of the vote can be ready almost immediately and displayed in a graphical manner . Department of AIML,VKIT 2023-24

10. Conclusion . 10 Efficiently managing election databases is vital for maintaining the credibility of elections. By leveraging PHP and SQL, election authorities can overcome challenges such as data accuracy, security, and handling large volumes of data. This will establish a reliable and streamlined system, enhancing the integrity and transparency of the electoral process. Implementing proper database management techniques is crucial for ensuring smooth and credible elections. Department of AIML,VKIT 2023-24

11. Thank You Vruthvik DS & Pavithra HN . Dept. of AIML,VKIT www.codeshack.io 11

12. 12 Large image Voting is the most precious right of every citizen,and we have a moral obligation to ensure the intergrity of our voting process