Design a simple database to track people and who they votedfor. The database should have 3 tables:
A table of candidates
A table of registered voters
A table of votes
The candidate table should provide a listing of all candidatesand information about the candidates.
The registered voter table should hold all registered votersand any pertinent information about them
The vote table should hold vote records for each candidatemade by the voters
Requirements:
The system should not allow duplicate voters to be added tothe registered voter table based on a voter_id number field
The system should reject duplicate votes by the samevoter
Pick the relevant fields needed for each table to make thesystem useful
Provide:
SQL code to create the three tables
SQL code to insert test data into the database
A SQL query to retrieve the vote of record of a particularindividual
