database help (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

zed -> 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 -> 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.



zed -> 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 -> 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.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
6.201172E-02