Hi ,
I want help in designing a Bonus System Database.
I am planning to organize contests on my site where in users will have to answer some 10 questions , and at the end of each day users points will be calculated, based on there answers.
Prizes can be given to top users daily,weekly,monthly.
Now, these points will serve as the user Bonus points for eligibility for sponsor prizes. let say
user 1 answers 10 questions has scored 20 points , than he will be eligible for some prize etc.
Now he will have a choice to redeem these points with the prize or carry these points for next Sponsor prize which is at 50 points.