Sup? Hey I havent been around latety, but I used to be a frequent visitor back when the "general mayhem" and "the bone closet" board was up and the "babe thread" and "icy hot stunners" where hot topics, but life changes and you lose touch, but i recently encountered a problem and figgured someone at the hard forum might know something about it...
I have a small business im starting, and i've already incorporated and have been somewhat successful doing small machine work, but I had this idea to create a website.... and I dont want to get into the details about it yet, but I have a problem and figgured this is the place to go...
I need someone to do some complicated (at least in my mind) SQL programming... I made a text doc of what i need done and will cut and paste it below...
BEGIN LIST...
"Basic needs
login/password system user enters desired login/password along with a valid email for password to be sent to enters info on age and location via ZIP code during sign up
user than needs to be able to download file from selection each selection needs to have a counter on it, and each file selection needs to have the opportunity to vote on 5 sets of 1-10 scales with results automatically totaled per scale
each of the 5 sets needs to have independent results, and an averaged combined total
a user can only vote once per file!!
a running total of each individual vote needs to be logged so that each month, each file can have a tally showing what percentage of the total votes was made by 5 specific age ranges, along with locations divided into 100 or so areas (zip codes run from 00012 on the each coast to 99089 on the west coast ) may be possible to divide by zip code numbers ie, 00012-09050 and so on international results may also need to capable of being registered, altho as of now, this is not necessary
basically I need to be able to compile the voting results of files downloaded into a presentable report presumably a very thick report
I need to be able to show
1. how many times an individual file was downloaded
2. the number of times an individual file had been voted on
3. the files average voting result of all 5 rating scales combined
4. the files average voting result per individual scale
5. an 5 part age divide, showing the average results among each divide.. ie, of 10-18 year olds - 10% gave it a 1, 5% gave it a 2, 30% gave it a 3 and so on these results could be compiled from the overall rating on all 5 rating scales combined, altho future situations could demand that all 5 be individually broke down
6. of the averaged results combined, a 100 part break down of where the results were cast using the supplied ZIP code when signing up
7. Insane request possibly a breakdown between age group and zip code, and maybe even a breakdown between individual voting scale results among age and zips ie, 10-18 year olds in 00012-09012 - Scale A - 34% voted a 1, 12% voted a 2, and so on, for each scale, for each file impossible?
im expecting thousands of votes across a wide variety of files the number of votes cast could grow rapidly I need to be able to handle this type of situation
am I crazy or what? Can this be done? At what cost? "
END LIST...
None of my freinds know much about databasing, but they tell me it isn't too hard to learn.... but i contacted a guy my girlfriends brother knows and he quoted me a $3000 - $6000 quote.... i laughed at him.... that was for a complete package, but me and my business partener had all ready created a website, email accounts, URL registration and the likes... still, just the databasing part he quoted me was around $3000, for that amount I could go to school and learn it all myself....
sorry this is so long, but my main questions are, is this quote way out of line, or would anyone here be interested in making an offer which would be paid cash (maybe around $500?) or a share of company profits.... anyone know SQL who is near the Cleveland OH area? Any takers?
Thanx - eo273
I have a small business im starting, and i've already incorporated and have been somewhat successful doing small machine work, but I had this idea to create a website.... and I dont want to get into the details about it yet, but I have a problem and figgured this is the place to go...
I need someone to do some complicated (at least in my mind) SQL programming... I made a text doc of what i need done and will cut and paste it below...
BEGIN LIST...
"Basic needs
login/password system user enters desired login/password along with a valid email for password to be sent to enters info on age and location via ZIP code during sign up
user than needs to be able to download file from selection each selection needs to have a counter on it, and each file selection needs to have the opportunity to vote on 5 sets of 1-10 scales with results automatically totaled per scale
each of the 5 sets needs to have independent results, and an averaged combined total
a user can only vote once per file!!
a running total of each individual vote needs to be logged so that each month, each file can have a tally showing what percentage of the total votes was made by 5 specific age ranges, along with locations divided into 100 or so areas (zip codes run from 00012 on the each coast to 99089 on the west coast ) may be possible to divide by zip code numbers ie, 00012-09050 and so on international results may also need to capable of being registered, altho as of now, this is not necessary
basically I need to be able to compile the voting results of files downloaded into a presentable report presumably a very thick report
I need to be able to show
1. how many times an individual file was downloaded
2. the number of times an individual file had been voted on
3. the files average voting result of all 5 rating scales combined
4. the files average voting result per individual scale
5. an 5 part age divide, showing the average results among each divide.. ie, of 10-18 year olds - 10% gave it a 1, 5% gave it a 2, 30% gave it a 3 and so on these results could be compiled from the overall rating on all 5 rating scales combined, altho future situations could demand that all 5 be individually broke down
6. of the averaged results combined, a 100 part break down of where the results were cast using the supplied ZIP code when signing up
7. Insane request possibly a breakdown between age group and zip code, and maybe even a breakdown between individual voting scale results among age and zips ie, 10-18 year olds in 00012-09012 - Scale A - 34% voted a 1, 12% voted a 2, and so on, for each scale, for each file impossible?
im expecting thousands of votes across a wide variety of files the number of votes cast could grow rapidly I need to be able to handle this type of situation
am I crazy or what? Can this be done? At what cost? "
END LIST...
None of my freinds know much about databasing, but they tell me it isn't too hard to learn.... but i contacted a guy my girlfriends brother knows and he quoted me a $3000 - $6000 quote.... i laughed at him.... that was for a complete package, but me and my business partener had all ready created a website, email accounts, URL registration and the likes... still, just the databasing part he quoted me was around $3000, for that amount I could go to school and learn it all myself....
sorry this is so long, but my main questions are, is this quote way out of line, or would anyone here be interested in making an offer which would be paid cash (maybe around $500?) or a share of company profits.... anyone know SQL who is near the Cleveland OH area? Any takers?
Thanx - eo273