Reportdbms

Online Voting System
TABLE OF CONTENTS
1. INTRODUCTION………………………………………………………………………………...
1.1 Aim of the Project……………………………………………………………………
1.2 Overview of the Project ………..................................................................................
1.3 Outcome of the Project ………………………………………………………………
1.4 Software Requirements……………………………………………………………….
1.5 Software Description………………………………………………………………..
2. SYSTEM ANALYSIS AND DESIGN

2.1 System Analysis
2.2 Module
2.3 Schema Diagram
2.4 E-R Diagram
2.5 Use Case Diagram
2.6 Data Flow Diagram
2.7 Sequence Diagram
3. IMPLEMENTATION
3.1 Description of Tables
3.2 Constraint on Table
3.3 Back End Implementations
3.4 Front End Implementations
4. RESULT ANALYSIS
4.1 Snap Shots
5. CONCLUSION AND FUTURE WORK

5.1 Conclusion
5.2 Future Enhancement
6. REFERENCES
Dept. of CS&E, MIT Mysore. 2023-24 1

Chapter 01
INTRODUCTION
In the dynamic landscape of modern democracy, the utilization of advanced technologies is
becoming increasingly vital for ensuring efficient and secure electoral processes. The Online
Voting System is a Database Management System (DBMS) mini project designed to streamline the
voting process, making it more accessible, convenient, and secure. This project aims to harness the
power of database management to handle voter registration, candidate information, and the voting
process in a comprehensive and organized manner.
1.1 Aim of the Project
The primary aim of the Online Voting System project is to modernize and optimize the
electoral process by leveraging database management technologies. The project seeks to enhance
accessibility, ensure security and integrity, simplify voter registration, facilitate informed decision-
making, improve efficiency, promote transparency, encourage public participation, and serve as a
model for future elections. Ultimately, the project aims to showcase the potential of Database
Management Systems in revolutionizing democratic processes for a more inclusive and efficient
voting experience.
1.2 Overview of the Project
The Online Voting System project is a pioneering initiative designed to transform traditional
voting methods into a modern, secure, and accessible electoral process. In response to the evolving
needs of democratic societies, this project leverages Database Management Systems (DBMS) to
create an online platform that simplifies voter registration, provides comprehensive candidate
information, and enables secure, transparent, and efficient voting. By embracing the capabilities of
DBMS, the project aims to enhance the integrity of elections, foster public engagement, and serve
as a scalable model for future electoral endeavors.
1.3 Outcome of the Project
The Online Voting System project envisions a transformative impact on the electoral
landscape, ushering in a new era of accessible, secure, and efficient voting processes. As a result of
this endeavor, we anticipate a paradigm shift in the democratic experience, characterized by several
key outcomes. Firstly, the implementation of an online platform promises unprecedented
accessibility, empowering voters to exercise their democratic right conveniently from any location
with internet access.
The project aims to streamline the voter registration process, introducing online registration to
contribute to the creation of a dynamic and accurate voter database. This, coupled with a
comprehensive candidate database, is poised to empower voters with detailed information about
candidates, fostering an electorate that is informed, engaged, and capable of making educated
voting decisions.
Efficiency and accuracy in election outcomes are anticipated through the automation of the voting
process, real-time monitoring, and result tabulation. This approach seeks to minimize manual errors
and delays, providing a more streamlined and transparent electoral process. Furthermore, the
project aims to encourage increased public participation by removing geographical barriers and
making voting more convenient, ultimately fostering a more engaged citizenry.
1.4 Software Requirements
 Operating System -Windows 7/8/10/11
 Web Server (preferably Apache)
 Phpmyadmin
 Xampp server
1.5 Software Description:
 XAMPP server (Php MyAdmin):
 XAMPP is a free and open-source cross-platform web server solution stack

package developed by Apache Friends, consisting mainly of the Apache
HTTP Server, MariaDB database, and interpreters for scripts written in the
PHP and Perl programming languages.
 XAMPP helps a local host or server to test its website and clients via computers
and laptop before releasing it to the main server. It is a platform that furnishes a
suitable environment to test and verify the working of projects based on
Apache, Perl, MySQL database, and PHP through the system of the host itself
Chapter 02
SYSTEM ANALYSIS AND DESIGN
2.1 System Analysis:
System analysis is a detailed of the various operations performed by a system and

their relationship within and outside the system. It is a systematic technique that defines goals
and objectives. The goal of system development is to develop a system in line with the user
requirement, and analysis of the system plays important role. One of the main aspects of
analysis is the defining the boundaries of the system.
The various tools of structured analysis are:
➢ Entity relationship diagram
➢ Table
➢ Table description
➢ Flow diagram
The various tools of structured analysis are:
➢ Entity relationship diagram
➢ Table
➢ Table description
➢ Flow diagram
2.2 Modules
Admin
 User Management
 Voter Registration
 Candidate Management
 Election Configuration
 Security and Authentication
 Vote Monitoring
 Results Management
 Report Generation
User
 Profile Management
 Voter Registration
 Candidate Information
 Voting Interface
 Election Information
 Results Viewing
 Communication Center
 History and Activity Log
 Accessibility Features
 Logout and Session Management
 Dashboard and Analytics
General Constraints
 User must have the knowledge of application working

process.
 Internet must be necessary for this application.
 Multiple users can login.
 The Application is available on all the device. It is compatible with all
browser and mobile.
Assumption and Dependencies
 User can use this application in any browser or mobile there is no
restriction but he should have internet facility
 User must have the knowledge of English
 We assume that the system must be user friendly and self-explanatory
External Requirements
It gives a description of the hardware, software and communication interface and
provide basic prototypes of the user interface. Functional requirements are defined according
to the development of the project.
 System Requirements
 Front end - HTML, CSS,
 Middle
- PHP, Java Script
layer
 Back end - MYSQL.
 Software Requirements
 Operating system - Windows XP – SP2 / 7 / 8.1 above.
 Browser - Google chrome.
 Hardware Requirements
 Processor - Dual Core (2.0) GHZ or Above
 RAM - 1 GB or Above
 Hard Disk - 20 GB and Above
2.3 Schema Diagram

2.4 E-R Diagram
Fig: E-R Diagram
2.5 Use Case Diagram

2.6 Data Flow Diagram

In this leve1 dataflow diagram represents primary data flow from other entities to admin
entity role.
The level one DFD helps in analyzing the workflow of Admin. In our application when
the admin login the databases are connected to the application and the modules within the
circle do their task according to the input given to them.
Admin Dataflow Diagram
2.7 Sequence Diagram

A sequence diagram shows object interactions arranged in a time sequence. It depicts
the object and classes involved in the scenario and the sequence of messages exchanged
between the objects needed to carry out the functionality of the scenario.
Sequence diagram is typically associated with use case realization in the logical view
of the system under development. Sequence diagrams are sometimes called event diagrams or
event scenario.
Sequence Diagram for Admin
 The admin login for the application check whether the username and password are correct
or wrong. The database check for the id and return success or error message.
 If error then go back to login or else dashboard appears
 Once the session and cookies are generated then there is only communication between the
dashboard and the database.
 In this module send the request and take back the response from the database and display
the output according to the user needs.
Chapter 03
IMPLEMENTATION
3.1 Description of Tables
3.1.1 Admin
3.1.2 Register
3.1.3 Nominee
3.2 Constraint on tables
Table name: Admin
Table name: Nominee
Table name: Register

3.3 Back End Implementations
<?php
session_start();
?>
<!DOCTYPE html>
<html>
<head>
<meta charset='utf-8'>
<meta http-equiv='X-UA-Compatible' content='IE=edge'>
<title>Admin</title>
<meta name='viewport' content='width=device-width, initial-scale=1'>
<link rel='stylesheet' type='text/css' media='screen' href='Log&adm.css'>
<link rel="stylesheet" href="https://pro.fontawesome.com/releases/v5.10.0/css/all.css"
integrity="sha384-
AYmEC3Yw5cVb3ZcuHtOA93w35dYTsvhLPVnYs9eStHfGJvOvKxVfELGroGkvsg+p"
crossorigin="anonymous"/>

</head>
<body>
<div class="login">
<h1>admin panel</h1>
<form action="" method="post" >
<center>
<input type="email" name="Username" required placeholder="Email"><br>
<input type="password" name="Password" required placeholder="Password"><br>
<button type="submit" name="submit" >Submit</button>
</center>
</form>
</div>
<button class="open-button" onclick="back()">Back</button>
<script>
function back(){
window.location="index.html";
}
</script>
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "voting_system";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
if(isset($_POST['submit'])){
$Username=$_POST['Username'];
$Password=$_POST['Password'];
$select="select * from admin where Username='$Username' and Password='$Password'";

$run=mysqli_query($conn,$select);
$row=mysqli_num_rows($run);
if($row==1){
echo "<script> window.open('adminPanel.php','_self') </script>";
$_SESSION['Username']= $Username;
}else{
echo "<h5 style='color:red;text-align:center;'>Wrong Username or Password</h5>";
}
}
?>
</body>
</html>
<!DOCTYPE html>
<html>
<head>
<title>Edit User</title>
<link rel='stylesheet' type='text/css' media='screen' href='Register.css'>
integrity="sha384-
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-
DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj"
crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js"
integrity="sha384-9/reFTGAW83EW2RDu2S0VKaIzap3H66lZH81PoYlFhbGU+6BZp6G7niu735
Sk7lN" crossorigin="anonymous"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
</head>
<body>
<div class="registerform">
<h1>Edit User Form</h1>
<?php
$conn = mysqli_connect('localhost', 'root', '', 'voting_system');
if(isset($_GET['edit'])){
$edit_email=$_GET['edit'];
$select="select * from register where Email='$edit_email'";

$row_user=mysqli_fetch_array($run);
$FullName=$row_user['FullName'];
$MobileNo=$row_user['MobileNo'];
$Email=$row_user['Email'];
$DOB=$row_user['DOB'];
$Password=$row_user['Password'];
}
?>
<form action="" method="POST" >
<input type="text" name="FullName" value="<?php echo $FullName; ?>" required
placeholder="Full Name">
<input type="tel" name="MobileNo" value="<?php echo $MobileNo; ?>" pattern="[1-9]
{1}[0-9]{9}" maxlength="10" required placeholder="Mobile NO"><br>
<input type="email" name="Email" value="<?php echo $edit_email; ?>" required
placeholder="Email">
<input type="date" name="DOB" value="<?php echo $DOB; ?>" required
placeholder="Date Of Birth"><br>
<input type="password" name="Password" value="<?php echo $Password; ?>" required
placeholder="Password">
<input type="password" name="RePassword" required placeholder="ReEnter
Password"><br>
</form>
</div>
<script>
function back(){
window.location="adminPanel.php";
}
</script>
<?php
$username = "root";
$password = "";
$eFullName=$_POST['FullName'];
$eMobileNo=$_POST['MobileNo'];
$eEmail=$_POST['Email'];
$eDOB=$_POST['DOB'];
$ePassword=$_POST['Password'];
$eRePassword=$_POST['RePassword'];
if($ePassword==$eRePassword){
$update="update register set

FullName='$eFullName',MobileNo='$eMobileNo',DOB='$eDOB',Password='$ePassword' where
Email='$edit_email'";
$run_update=mysqli_query($conn,$update);
if($run_update===true){
echo "<H5 style='color:green;text-align:center;'>Successfully Updated</h5>";
}else{
echo "<center><H5 style='color:red;text-align:center;'>Not
Inseted</h5></center>".mysqli_error($conn);
}
}else{
echo "<H5 style='color:red;text-align:center;'>Password is not Matched with RE-Entered
Password</h5>";
}
}
?>
</body>
</html>
<?php
session_start();
?>
<!DOCTYPE html>
<html>
<head>
<title>login</title>
<link rel='stylesheet' type='text/css' media='screen' href='Log&adm.css'>
integrity="sha384-
</head>
<body>
<div class="login">
<h1>Login</h1>
<form action="" method="POST">
<center>
<input type="email" name="Email" required placeholder="Email"><br>

<input type="date" name="DOB" required placeholder="Date Of Birth"><br>
<input type="password" name="Password" required placeholder="Password"><br>
<button type="submit" name="submit" >Submit</button><br>
<a href="admin.php">or Admin Login?</a>
</center>
</form>
</div>
<script>
function back(){
}
</script>
<?php
$username = "root";
$password = "";
$Email=$_POST['Email'];
$DOB=$_POST['DOB'];
$select="select * from register where Email='$Email' and Password='$Password'and

DOB='$DOB'";
// $row_user=mysqli_num_rows($run);
$row_user=mysqli_fetch_array($run);
// $dbEmail=$row_user['Email'];
// $dbDOB=$row_user['DOB'];
// $dbVoted=$row_user['Voted'];
// $dbPassword=$row_user['Password'];
if(is_array($row_user)){//$Email==$dbEmail && $Password==$dbPassword

echo "<script> window.open('LoginSuccess.php','_self') </script>";
$_SESSION['Email']=$row_user['Email'];// $dbEmail;
$_SESSION['Voted']=$row_user['Voted'];// $Voted;
}else{
echo "<h5 style='color:red;text-align:center;'>Wrong Username or
Password</h5>".mysqli_error($conn);
}
}
?>
</body>
</html>
<!DOCTYPE html>
<html>
<head>
<title>Register</title>
<link rel='stylesheet' type='text/css' media='screen' href='Register.css'>
integrity="sha384-
</head>
<body>
<div class="registerform">
<h1>Registration Form</h1>
<form action="" method="POST" >
<input type="text" name="FullName" required placeholder="Full Name">
<input type="tel" name="MobileNo" pattern="[1-9]{1}[0-9]{9}" maxlength="10" required
placeholder="Mobile NO"><br>
<input type="email" name="Email" required placeholder="Email">
<input type="date" name="DOB" required placeholder="Date Of Birth"><br>
<input type="password" name="Password" required placeholder="Password">
<input type="password" name="RePassword" required placeholder="ReEnter
Password"><br>
</form>
</div>
<script>
function back(){
}
</script>
<?php
$username = "root";
$password = "";
$FullName=$_POST['FullName'];
$MobileNo=$_POST['MobileNo'];
$Email=$_POST['Email'];
$DOB=$_POST['DOB'];
$RePassword=$_POST['RePassword'];
if($Password==$RePassword){
$insert="insert into register(FullName,MobileNo,Email,DOB,Password,Status,Voted)

values('$FullName','$MobileNo','$Email','$DOB','$Password','OFF','NO')";
$run_insert=mysqli_query($conn,$insert);
if($run_insert===true){
echo "<H5 style='color:green;text-align:center;'>Successfully Inseted</h5>";
}else{
echo "<H5 style='color:red;text-align:center;'>Not Inseted</h5>".mysqli_error($conn);
}
}else{
echo "<H5 style='color:red;text-align:center;'>Password is not Matched with RE-Entered
Password</h5>";
}
}
?>
</body>
</html>
3.4 Front End Implementations
<!DOCTYPE html>
<html>
<head>
<title>Front Page</title>
<meta name='viewport' content='width=device-width, initial-sScale=1'>
<link rel='stylesheet' type='text/css' media='screen' href='index.css'>
integrity="sha384-
crossorigin="anonymous" />
</head>
<body>

<div class="bg">
<header class="header navbar-fixed-top">
<ul>
<li><a href="#">India</a></li>
<li><a href="#">Home</a></li>
<li><a href="#about">About</a></li>
<li><a href="#view">View</a></li>
<li><a href="Login.php">Login</a></li>
</ul>
</header>

<section class="cent">
<h1 id="text">" Your Vote <br> Your Voice "</h1>
<br><br>
<a href="Register.php" id="btn">Register</a>

</section>
</div>

<div class="second" id="about">

<br><br>
<h1 >About</h1>
<h2>
" EVERY VOTE MATTERS "
</h2>
<br><br>
<p>An online voting system is a software platform that allows groups to securely conduct
votes. High-quality
online voting systems
balance ballot security, accessibility, and the overall requirements of an organization's
voting
event.<br><br>
At their core, online voting systems protect the integrity of your vote by preventing voters
from being able
to vote multiple times.
As a digital platform, they eliminate the need to gather in-person, cast votes using paper, or
by any other
means
(e.g. email, insecure survey software).<br><br>
You may hear an online voting system being referred to as an online e- voting system, or
electronic voting.
These all make reference to the same thing: a secure voting tool that allows your group to
collect input
from your group
and closely scrutinize the results in real time.<br><br><br><br>
</p><br><br>
</div>

<div class="third" id="view">

<br><br>
<h1 >View</h1>
<br><br>
<div class="card">
<br><br>
<i class="fas fa-poll-h fa-10x" style="color: black;"></i>
<h1>Result</h1><br><br>
<p><a href="Result_Index.php">View</a></p>
</div>
<br><br>

</div>

<footer>
<center>
<div class="sociallogo">
<a href="#"><i class="fab fa-facebook fa-2x"></i></a>
<a href="#"><i class="fab fa-instagram fa-2x"></i></a>
<a href="#"><i class="fab fa-twitter fa-2x"></i></a>
<a href="#"><i class="fab fa-linkedin fa-2x"></i></a>
</div>
<address>
<br>
<h4>Contact</h4>
" MYSORE, KARNATAKA "<br><br>
[email protected]<br>
[email protected]<br>
999XXXXXX
</address> <br>
&copy Copyright 2021 by XXX. All Right Reserved
</center>
</footer>
</body>
</html>
@import url('https://fonts.googleapis.com/css2?family=Rancho&display=swap');
@import url('https://fonts.googleapis.com/css2?family=Orelega+One&display=swap');
@import url('https://fonts.googleapis.com/css2?family=Bebas+Neue&display=swap');
*{
margin: 0;
padding: 0;
box-sizing: border-box;
/* font-family: 'Orelega One', cursive; */
font-family: 'poppins',sans-serif;
}
body{
margin: 0;
padding: 0;
min-height: 100vh;
}
.bg{
background-image:url("Images/voting2.jpg");
background-repeat: no-repeat;
/* background-attachment: fixed; */
background-position: center;
background-size: cover;
}
.header{
top: 0;
left: 0;
width: 100%;
padding: 10px 20px;
background-color: rgb(31, 110, 116);
}
.header ul{
display: flex;
justify-content: center;
align-items: center;
}
.header ul li{
list-style: none;
margin-left: 20px;
}
.header ul li a{
text-decoration: none;
padding: 4px 15px;
color: #fff;
font-size: 25px;
font-family: 'Rancho', cursive;
border-radius: 20px;
}
.header ul li a:hover{
background: black;
}
.cent{
position: relative;
width: 100%;
min-height: 100vh;
display: flex;
justify-content: center;
align-items: center;
}
section #text{
color: rgb(138, 14, 14);
font-size: 8vw;
text-align: center;
font-weight: bolder;
/* font-family: 'Bebas Neue', cursive; */
/* margin-right: 50%; */
text-shadow:7px 5px 5px rgb(247, 129, 32);
}
section #text:hover{
animation: vote 0.5s ease-out ;
}
@keyframes vote{
0%{
}
50%{
font-size: 10vw;
}
100%{
}
}
#btn{
position:absolute ;
text-decoration: none;
display: inline-block;
padding: 8px 30px;
background:black;
color: #fff;
font-size: 1.2em;
font-weight: 500;
letter-spacing: 2px;
border-radius: 40px;
transform: translateY(260px);
}
#btn:hover{
box-shadow: 5px 5px 10px gray;
}
.second{
/* position: relative; */
padding: 20px;
background: cadetblue;
min-height: 100vh;
}
.second h1{
font-size:35px;
color: #fff;
margin-bottom: 10px;
text-align: center;
}
.second h2{
font-size:35px;
color: #fff;
font-family: 'Bebas Neue', cursive;
text-align: center;
margin-bottom: 10px;
}
.second p{
font-size: 18px;
color: #fff;
}
.third{
background-image: url("Images/Result-bg.jpg");
background-repeat: no-repeat;
background-attachment: fixed;
background-position: center;
background-size: cover;
min-height: 100vh;
}
.third h1{
font-size:35px;
margin:20px 20px;
color: blue;
text-align: center;
font-weight: 400;
}
.card {
box-shadow: 0 4px 8px 0 rgba(0, 0, 0, 0.2);
max-width: 300px;
height: 400px;
margin: auto;
text-align: center;
font-family: arial;
background: linear-gradient(to right, #26D0CE, #1A2980);
.card a {
padding: 12px;
color: white;
background-color: #000;
text-align: center;
font-size: 18px;
}
.card a:hover {
opacity: 0.7;
}
footer{
padding: 20px;
margin: 0px;
background: cadetblue;
}
.sociallogo{
text-align: center;
padding: 10px;
}
.sociallogo a{
margin: 7px;
color: #111111;
position: relative;
}
.sociallogo a:hover{
color: aqua;
}
@media screen and (max-width:620px) {
section #text{
font-size: 80px;
}
}
@media screen and (max-width:480px) {
.header .logo{
font-weight: 400;
font-size: 20px;
}
.header ul li{
margin-left: 5px;
}
.header ul li a{
padding: 6px 10px;
font-size: 20px;
}
section #text{
font-size: 60px;
}
Chapter 04
RESULT ANALYSIS
4.1 Snapshots
Fig 4.1.1 Home Page
Fig 4.1.2 Register Page

Fig 4.1.3 Login Page
Fig 4.1.4 Admin Login page

Fig 4.1.5 User Voting Page
Fig 4.1.6 Admin Panel

Fig 4.1.7 Result Announcement Page

Chapter 05
CONCLUSION AND FUTURE WORK
5.1 Conclusion
In conclusion, the development of the online voting system has been a significant
undertaking, aiming to streamline the electoral process and enhance accessibility for voters.
Through the course of this project, several key accomplishments have been achieved,
including the successful design and implementation of a robust database management system
to handle voter information, candidate details, and voting transactions.
The system has demonstrated its effectiveness in providing a user-friendly interface for
voters to cast their ballots securely and efficiently. Moreover, the integration of a well-
structured database has ensured data integrity, accuracy, and reliability throughout the voting
process.
5.2 Further Enhancement
While the current project marks a significant milestone in the development of an online voting
system, there are several avenues for future work and improvement:
 Enhanced Security Measures: Implement additional layers of security to protect against

potential threats and ensure the integrity of the voting system.
 Scalability: Investigate options for scaling the system to accommodate a larger number of
voters and elections, ensuring optimal performance.
 User Authentication: Explore advanced authentication methods to further enhance the
identification and verification of voters, preventing unauthorized access.
 Data Analytics: Integrate data analytics tools to analyze voting patterns, providing valuable
insights for election organizers and policymakers.
 Mobile Application: Develop a mobile application to make the voting process even more
accessible, allowing users to cast their votes from smartphones.
 Blockchain Integration: Investigate the integration of blockchain technology to enhance
transparency, security, and traceability of the voting transactions.
In conclusion, the online voting system project has laid a solid foundation, and further development
and refinement can lead to an even more robust and efficient electoral platform in the future. The
ongoing commitment to innovation and addressing the evolving needs of the electoral process will
contribute to the success and sustainability of the system.
Chapter 06
REFERENCES
1.Fundamentals of Database Management System by Pearson author Navathe 7th.
2.PHP Pandas by Daylee rees.
3.Learn to code HTML and CSS by shay Howe.
4.Software engineering by Roger S. Pressman.
5.HTML Tutorial - https://www.w3schools.com/html
6.CSS Tutorial - https://www.w3schools.com/Css
7.PHP Tutorial - https://www.w3schools.com/php
8.JS Tutorial - https://www.w3schools.com/Js
9.Google and Youtube videos

Reportdbms

Uploaded by

Copyright:

Available Formats

Reportdbms

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Reportdbms

Uploaded by

Copyright:

Available Formats

Online Voting System

2. SYSTEM ANALYSIS AND DESIGN

5. CONCLUSION AND FUTURE WORK

Dept. of CS&E, MIT Mysore. 2023-24 1

1.4 Software Requirements

 Operating System -Windows 7/8/10/11

 Web Server (preferably Apache)

1.5 Software Description:

 XAMPP server (Php MyAdmin):

 XAMPP is a free and open-source cross-platform web server solution stack

SYSTEM ANALYSIS AND DESIGN

2.1 System Analysis:

System analysis is a detailed of the various operations performed by a system and

 User must have the knowledge of application working

 Processor - Dual Core (2.0) GHZ or Above

 Hard Disk - 20 GB and Above

2.3 Schema Diagram

2.4 E-R Diagram

Fig: E-R Diagram

2.5 Use Case Diagram

2.6 Data Flow Diagram

2.7 Sequence Diagram

Sequence Diagram for Admin

3.1 Description of Tables

3.2 Constraint on tables

Table name: Admin

Table name: Nominee

Table name: Register

3.3 Back End Implementations

<button class="open-button" onclick="back()">Back</button>

$select="select * from admin where Username='$Username' and Password='$Password'";

$select="select * from register where Email='$edit_email'";

<button class="open-button" onclick="back()">Back</button>

$update="update register set

<input type="email" name="Email" required placeholder="Email"><br>

<button class="open-button" onclick="back()">Back</button>

$select="select * from register where Email='$Email' and Password='$Password'and

if(is_array($row_user)){//$Email==$dbEmail && $Password==$dbPassword

<button class="open-button" onclick="back()">Back</button>

$insert="insert into register(FullName,MobileNo,Email,DOB,Password,Status,Voted)

<div class="second" id="about">

<div class="third" id="view">

Fig 4.1.1 Home Page

Fig 4.1.2 Register Page

Fig 4.1.3 Login Page

Fig 4.1.4 Admin Login page

Fig 4.1.5 User Voting Page

Fig 4.1.6 Admin Panel

Fig 4.1.7 Result Announcement Page

 Enhanced Security Measures: Implement additional layers of security to protect against

1.Fundamentals of Database Management System by Pearson author Navathe 7th.

2.PHP Pandas by Daylee rees.

3.Learn to code HTML and CSS by shay Howe.

4.Software engineering by Roger S. Pressman.

5.HTML Tutorial - https://www.w3schools.com/html

6.CSS Tutorial - https://www.w3schools.com/Css

7.PHP Tutorial - https://www.w3schools.com/php