Hello.
I got the mission to build a contest-page, where visitors are supposed to submit codes which they can collect from a non-digital media.
Every code must be absolutely unique, but a person can enter more than one code (and increase their chances to win).
My client wants to overview all entries, and simply pick a winner. I want to split this into two tables, Contestants and Entries.
Each code entered gives the contestant one chance to win, if a contestant have entered correct answer two times, it gives him/her two chanses to win, and so on..
So I thinking of a solution like this:
A HTML-form (asp.net) with all the fields.If contestant (his/her unique peoperty like email) doesnt exist in DB, create a new contestant Contestants-tabl ...
Go to the complete details ...