I am helping my niece with her SBA IT project re Trinbarjam National Elections
Database Management
You are asked to use a suitable application to manage data on candidates nominated to contest seats in the
general elections. Three tables/files must be used to store the data. Relevant personal data on each
candidate should be stored, including name, address, date of birth, sex, profession, constituency, party
acronym and total votes received. Each candidate pays a deposit of $5000. (This deposit is refunded should
the candidate garner 20% or more of the votes cast in his constituency).
Constituency data must also be maintained, including the constituency name, number of electors, number
of votes cast, and number of special votes. The name and acronym of each party must also be stored. Data
must be sourced from the spreadsheet section of your project.
You should test your database by generating queries to find the following.
1. The candidate ID, name, sex, age and profession of all candidates from the Peoples Democratic
Revolution (PDR).
2. The candidate name, party acronym, number of electors and number of votes received for
candidates in constituencies with more than 6500 voters and where the candidates received less
than 500 of the votes cast.
3. Special votes expressed as a percentage of the overall number of voters in each constituency. Your
query should also show the constituency name field. The percentage should be expressed to two
places of decimal.
4. The candidates who received less than 20% of votes in their constituencies. Your query should
show the candidate(s) name, party acronym, constituency, number of voters and votes received.
All male candidates who are less than or equal to 40 years old and who received more than 40% of
the votes cast in their respective constituencies. You must also show the dates of birth, name,
number of votes received as well as the number of voters.
6. Calculate the sum of the deposits to be refunded to each party (only candidates who received 20
percent or more of votes are eligible for refund). Show the party name, acronym and sum
refunded to each party.
Generate a report which lists the final results of the election. The report should list the constituency, party
acronym, number of votes received, sex and name of candidates. The report should be sorted by
constituency. Within each constituency the report should be sorted by number of votes received. It should
also give the total and average number of votes cast in each constituency. The report should have a two-line
title as follows: "Official Results Trinbarjam National Elections"