| Author |
Topic |
|
jwenglish26
Starting Member
3 Posts |
 Posted - 2010-11-12 : 16:10:09
|
| I am building a web site that could have the potential for thousands of people to fill out an entry form. The first time a person does this each month they will be charged a $9 membership fee but may fill out several entry forms each month and i only need to charge them the $9 once a month. This is my first stab at using a database in a web site so if anyone could help me out i would greatly appriciate it.J.W.English |
|
|
TimSman
Posting Yak Master
127 Posts |
Posted - 2010-11-12 : 16:13:34
|
| Is there already a database in place, or are you starting from scratch? |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
jwenglish26
Starting Member
3 Posts |
Posted - 2010-11-12 : 16:36:16
|
| TimSman-- I am starting from scratchXD0254-- No I do not have an ER Diagram dont even know what that is, as for paying $9 to fill out forms its a little more complex than that. I am building a online bowling tournament site for a client and this is the first time i have tackled anything of this magnitude. thank you all for any help you can give me on this.J.W.English |
|
|
|
TimSman
Posting Yak Master
127 Posts |
Posted - 2010-11-12 : 16:40:01
|
| My suggestion is that you find someone who has experience with this sort of thing, and hire him or her. |
|
|
|
jwenglish26
Starting Member
3 Posts |
Posted - 2010-11-12 : 16:42:50
|
| would like to learn it for myself for future applications i cant imagin it could be that hard. I can use MS SQL and MS Access but not sure how to intergrate that into Dreamweaver.J.W.English |
|
|
|
TimSman
Posting Yak Master
127 Posts |
Posted - 2010-11-12 : 16:45:56
|
| Yeah, designing and building a database isn't difficult. Designing and building a database that works well and is scalable is trickier.You are essentially asking people to come up with a data architecture. People get paid a fair amount of money to do just that. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2010-11-12 : 16:46:40
|
| well...that's not badFIRST THING I would doI would make a list of all the data elements that need to be capturePeople Stuffregistration stuffAlley infoGame InfoFrame infoall those things...and then I would make Entites (kinda like what I just guessed at above)Then I would relate all of those Entities like a person plays at an AlleyThen I would type and size and identify the required (null) for eachTHEN I would create the databaseTHEN I Would slam in some sample data to validate the modelI would then build a process flow diagram and identify what info is required for each, and what functions should occurTHEN, and only THEN would I have somebody (I don't do web pages) build the application..and I would write the sprocsI would at thatsame timBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxWant to help yourself?http://msdn.microsoft.com/en-us/library/ms130214.aspxhttp://weblogs.sqlteam.com/brettk/http://brettkaiser.blogspot.com/ |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
TimSman
Posting Yak Master
127 Posts |
Posted - 2010-11-12 : 16:51:18
|
quote:
Originally posted by X002548
quote:
Originally posted by TimSman
Yeah, designing and building a database isn't difficult.
Says you..know what it's like to describe RI to people who don't understand?Brett
Hey, I said that doing it well is hard! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-11-13 : 05:48:02
|
| We do eCommerce stuff. Apart from the task of building the database and application there are issues on the web to consider with Permissions and "returning users"I fill in my first form of the month, and pay you $9.How do I fill in more forms that month?Do I get a token/voucher that I can use? Thanks - I'll give it to all my friends!is there a cookie on my PC? how do I use my other PC at work?Do I have to Register and then the Payment is recorded on my Account? Are people going to be bothered to register?(Same problem in eCommerce - Register and then Buy - puts people off. One-page-checkout means no-one bothers to login any more and you wind up sending 10 catalogues to the same address in the mail)Lots of support-avoidance code needed - lost password, Email address was typed wrongly, how does the user recover from that? (they can't Email themselves an account-recovery-code, you can't just let them type in a new email address otherwise, thank you very much!, I'll change my mate's account to my email address 'coz I know he's paid this month).I don't want to put a "downer" on it, but there is a lot of logic of that type in a website to make it work well without people needing lots of hand-holding |
|
|
|
|
Dont know what to do.