Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

COLLEGE ELECTION AND VOTING SYSTEMS USING DBMS, Study Guides, Projects, Research of Database Management Systems (DBMS)

A project report on COLLEGE ELECTION AND VOTING SYSTEMS USING DBMS

Typology: Study Guides, Projects, Research

2024/2025

Available from 06/13/2025

anshy-prabha
anshy-prabha 🇮🇳

5 documents

1 / 26

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
COLLEGE ELECTION AND VOTING
SYSTEMS USING DBMS
21CSC205P/DATABASE MANAGEMENT SYSTEMS
PROJECT REPORT
Submitted by
Drisya syam kumar RA2311003050228
Anshy prabha RA2311003050227
Under the guidance of
Dr. Rahmath Nisha
(Assistant Professor, School of Computing)
in partial fulfilment for the award of the degree
of
BACHELOR OF TECHNOLOGY
in
COMPUTER SCIENCE OF ENGINEERING
Of
FACULTY OF ENGINEERING AND TECHNOLOGY
SRM INSTITUTE OF SCIENCE AND
TECHNOLOGY TIRUCHIRAPPALLI
1
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a

Partial preview of the text

Download COLLEGE ELECTION AND VOTING SYSTEMS USING DBMS and more Study Guides, Projects, Research Database Management Systems (DBMS) in PDF only on Docsity!

COLLEGE ELECTION AND VOTING

SYSTEMS USING DBMS

21CSC205P/DATABASE MANAGEMENT SYSTEMS

PROJECT REPORT

Submitted by

Drisya syam kumar RA

Anshy prabha RA

Under the guidance of

Dr. Rahmath Nisha

(Assistant Professor, School of Computing) in partial fulfilment for the award of the degree of

BACHELOR OF TECHNOLOGY

in COMPUTER SCIENCE OF ENGINEERING Of FACULTY OF ENGINEERING AND TECHNOLOGY

SRM INSTITUTE OF SCIENCE AND

TECHNOLOGY TIRUCHIRAPPALLI

SRM INSTITUTE OF SCIENCE AND

TECHNOLOGY

(Deemed to be University U/S3 of UGC Act, 1956)

BONAFIDE CERTIFICATE

Certified that this project report titled COLLEGE ELECTION AND VOTING SYSTEMS USING DBMS is the Bonafide work of Drisya syam kumar (RA2311003050228 ) Anshy prabha (RA2311003050227) who carried out the project work under my supervision. Certified further, that to the best of my knowledge the work reported here in does not form any other project report ordissertation on the basis of which a degree or award was conferred on an occasion on this or any other candidate. SIGNATURE Dr.Rahmath Nisha Assistant Professor School of Computing SRM Institute of Science and Technology, Tiruchirappalli. SIGNATURE Kanaga Suba Raja S Head of the Department SRM Institute of Science and Technology, Tiruchirappalli. Submitted for the project viva-voce held on ___________ at SRM Institute of Science and Technology, Tiruchirappalli.

ABSTRACT The College Election & Voting System is a secure, dynamic, and educational web application designed to revolutionize the way student elections are conducted in academic institutions. Built to replace traditional paper-based voting methods, this platform ensures greater transparency, accuracy, and accessibility by leveraging modern technologies like PHP (via XAMPP server), MySQL, HTML, CSS, and JavaScript. The system creates a digital environment where each student can participate in a fair and tamper-proof electoral process with just a few clicks. To transform the way student elections are held in educational institutions, the College Election & Voting System is a dynamic, safe, and instructive web application. Designed to take the place of conventional paper-based voting procedures, this platform uses PHP (through the XAMPP server), MySQL, HTML, CSS, and JavaScript to provide increased transparency, accuracy, and accessibility. With just a few clicks, the system establishes a digital environment in which every student can take part in an impartial and impenetrable electoral process. Voters can safely log in, cast their ballots, and view election results in real time thanks to the system's user-friendly interface. By using authentication and one-

person-one-vote, it gets rid of common problems like duplicate voting, manual counting errors, and voter impersonation. Ultimately, the project is a fusion of education, technology, and civic engagement —encouraging participation, reducing resource waste, and laying the groundwork for more scalable e-governance solutions in the future.

LIST OF FIGURES

3.1 Block Diagram 14

3.2 ER Diagram 14

CHAPTER 1

INTRODUCTION

1.1INTRODUCTION

Even the most conventional procedures are being rethought through technology in the rapidly changing world of digital transformation. Election administration is one such crucial area, particularly in college settings where student representation and participation are essential. A contemporary approach to digitizing the electoral process while guaranteeing security, efficiency, and fairness is the College Election & Voting System. Just as gaming projects help beginners understand the fundamentals of programming, web-based systems like this voting platform serve as hands-on learning models for database management, server-side scripting, authentication mechanisms, and user interface design. This project allows students to engage not just as voters, but also as future developers exploring how real-world applications are structured and built. By combining MySQL for secure data handling, PHP for backend logic, and HTML/CSS/JavaScript for the interface, this system brings together core concepts of full-stack development in a practical and impactful way. As we explore the components of this system, we will uncover how it bridges theoretical DBMS principles with real-time functionality, all while promoting democratic values within the academic community.

This project further aims to automate the entire election process, from candidate registration to result generation, thereby reducing human error, time consumption, and administrative overhead. By implementing key features such as a user-friendly admin panel, secure vote storage, and live analytics, the system ensures that both voters and organizers benefit from an intuitive and seamless experience. Another important objective is educational: the system serves as a learning platform to help developers apply concepts of database management, client- server architecture, backend scripting, and frontend design. It provides hands-on experience in using tools such as MySQL, PHP (via XAMPP), and web technologies like HTML, CSS, and JavaScript. Furthermore, the project highlights how digital transformation can enhance governance within institutions and serves as a potential prototype for broader e-voting applications in schools, universities, clubs, and organizations

1.4 SCOPE AND MOTIVATION:

The College Election & Voting System addresses the inefficiencies and limitations of traditional voting methods in academic settings. It promotes transparency, boosts voter participation, and minimizes human errors and manual work. The project’s scope includes creating a platform that handles user authentication, vote casting, real-time result updates, and administrative control,

all while maintaining data integrity. This system encourages students to engage in democratic processes, and motivates developers by incorporating critical components like session management, user roles, secure data handling, and interface design—making it an ideal learning experience in full-stack web development.

integrated environment for developing and testing the application on local machines before deployment. The use of PHP allows for dynamic data handling and server-side logic, while HTML, CSS, and JavaScript provide a responsive and user-friendly interface for voters and administrators alike. Overall, the current system setup supports secure authentication, easy navigation, and quick result generation. It allows for efficient data validation, role-based access control, and integration of features like live vote counts and audit trails. The hardware and software combination used in this project ensures the system is functional, scalable, and accessible on most commonly available computing devices.

CHAPTER 3

ER DIAGRAM AND PROPOSED METHODOLOGY

3.1 BLOCK DIAGRAM

Fig 3.1 Block Diagram

PROPOSED METHODOLOGY

The main entities include- Voter Attributes : Voter ID, Name, Email, Registered Status Relationships : Can cast one vote.

Vote Submission : After selecting, voters confirm their vote, which is securely stored in the database.  Result Calculation : Once voting ends, the system calculates and stores results.  Display Results : After tallying, the system displays election results to the admin.  System Termination : The system ends the election process, ensuring no further voting is allowed post-deadline.

CHAPTER 4

IMPLEMENTATION

4.1 IMPLEMENTATION

XAMPP hosting SQL and Apache

CHAPTER 5

RESULTS AND DISCUSSION

5.1 RESULT:

Output of the Program: Fig 5.1 Admin login Fig 5.2 Voter Login

  • Abstract Page .no
  • 1 Introduction - 1.1 Introduction - 1.2 Problem Statement - 1.3 Objectives - 1.4 Scope and Motivation
  • 2 Existing System
  • 3 Design (ER Diagram) and Proposed Methodology
  • 4 Implementation
  • 5 Result and Discussion
  • 6 Conclusion
  • 7 References
  • 8 Appendix: 1- Publication/Presentation Proof
    • Admin Dashboard Fig 5.
  • Add/Remove voters Fig 5.