|
| |
|
|
zed
Posts: 7
Joined: 3/13/2004
Status: offline
 |
database help - 3/19/2004 9:00:34
im making a web-site where you can buy Dvd,s
So the tables i have are Customer, Dvd, Catergory,
users must login with password to purchase Dvd's so do i need to Password and UserID fields in the Customer table or in a new table.
Will i also need a order table.
I want to be able to administer the site over the web For instance add & delete customers and Dvd's.
To i need a table for these things .
Is it easier to Data Access Pages to make form in access. Or can Frontpage do it simpler
|
|
|
|
Richard Dudley
Posts: 668
Joined: 8/22/2002
From: Butler, PA
Status: offline
|
RE: database help - 3/19/2004 9:45:00
You are seriously trying to reinvent the wheel here, and when customer information is involved (especially credit card data), it's not a world where newbies should tread. The people who want this information for nefarious reasons are extremely intelligent and well skilled at obtaining the information from a poorly designed site.
I think you would be much better off looking for a hosted shopping cart solution (such as the one our gracious host provides), or investing in shopping cart software such as OS Commerce, Store Front, or Sales Cart Pro (review at http://www.frontpagewebmaster.com/m-187747/tm.htm).
If you want to make money being an on-line retailer, than be a retailer, not a developer. You'll be able to focus more on your business when you don't have to do everything from scratch.
< Message edited by Richard Dudley -- 3/19/2004 9:47:28 >
_____________________________
I need to change my avatar--the puppy is full grown now!
| |
|
|
|
zed
Posts: 7
Joined: 3/13/2004
Status: offline
|
RE: database help - 3/19/2004 16:56:18
Ok May the cart is a bit to much!!
But how about i make the website allow customers to borrow the Dvd's like a library system.( how could i make this work)
would i then need a Dvd Loan table.
| |
|
|
|
Richard Dudley
Posts: 668
Joined: 8/22/2002
From: Butler, PA
Status: offline
|
RE: database help - 3/19/2004 17:55:20
Think through your business process first, then design your database around that. If you didn't have a website, or a database, but maybe were a librarian in a small library, how would you loan DVDs out? Or maybe if you're a video rental store in 1984?
You would need some way for your visitors to browse the DVDs, and choose the ones they'd like to borrow.
You would need some way for the customers to identify themselves.
You would need some way for the customers to know when the DVD was due back. What happens if the DVD is not returned on time?
You need some way for the customers to return the DVDs.
The more you think about what you'll need to do, the more you'll probably see a good shopping cart solution will fit the bill for a loaner library first.
I don't want to discourage you--you sound like a person with an idea you'd like to fulfill. I'm not sure you know where to start. Your database comes near the middle of the process. Work your business out fully first.
_____________________________
I need to change my avatar--the puppy is full grown now!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
