Create a stored Procedure called PreferenceDistribution() The result should count the number of votes casted, if the
Fantastic news! We've Found the answer you've been seeking!
Question:
Create a stored Procedure called PreferenceDistribution()
The result should count the number of votes casted, if the candidate got more than 50% of the vote, it should win the election. The round should be based on how many the candidates are competing. Lets assume there are (n) number of candidates, then there should be (n-2) rounds.
The stored procedure should show the number of round, the name of the candidates, and how many votes they got on the round, the candidate with least vote will be eliminated and the number of votes the eliminated candidate has will be redistributed to the candidate that are still standing based on the preferences.
Related Book For
Canadian Income Taxation planning and decision making
ISBN: 9781259094330
17th edition 2014-2015 version
Authors: Joan Kitunen, William Buckwold
Posted Date: