Election Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Election Management System Entity. The entity-relationship diagram of Election Management System shows all the visual instrument of database tables and the relations between Candidates, Votes, Elections, poll etc. It used structure data and to define the relationships between structured data groups of Election Management System functionalities. The main entities of the Election Management System are Elections, Candidates, Election Commision Rules, Votes, Registration and poll.

Election Management System entities and their attributes :

• Elections Entity : Attributes of Elections are election_candidate_id, election_citizen_id, election_date, election_type, election_timing, election_description
• Candidates Entity : Attributes of Candidates are candidate_id, candidate_voter_id, candidate_name, candidate_mobile, candidate_email, candidate_username, candidate_password, candidate_address
• Election Commision Rules Entity : Attributes of Election Commision Rules are commision_rule_id, commision_rule_name, commision_rule_type, commision_rule_description
• Votes Entity : Attributes of Votes are vote_candidate_id, voe_citizen_id, vote_date, vote_type, vote_timing, vote_description
• Registration Entity : Attributes of Registration are registeration_id, registeration_candidate_id, registeration_citizen_id, registeration_name, registeration_type, registeration_description
• poll Entity : Attributes of poll are poll_id, poll_name, poll_type, poll_description

Description of Election Management System Database :

• The details of Elections is store into the Elections tables respective with all tables
• Each entity (poll, Election Commision Rules, Registration, Candidates, Elections) contains primary key and unique keys.
• The entity Election Commision Rules, Registration has binded with Elections, Candidates entities with foreign key
• There is one-to-one and one-to-many relationships available between Registration, Votes, poll, Elections
• All the entities Elections, Registration, Election Commision Rules, poll are normalized and reduce duplicacy of records
• We have implemented indexing on each tables of Election Management System tables for fast query execution.