Re: Database Design for Shopping Cart

Download the IBuySpy.com sample and it includes all the scripts required to generate a shopping-cart database. It's very easy to understand.

Good luck!

"Art" <ashannon_at_sfsu.edu> wrote in message news:U0qD8.1004$1s3.58136625_at_newssvr21.news.prodigy.com...
> I have an assignment to develop shopping web site and I would like to ask
> about how to do a good design for the database system that will support
> shopping cart?
>
> I designed one and it has one shoppingcart table that contains only one
> field, UserID, which I feel weird. It looks like this:
>
> tblShoppingCart tblCartDetail
> tblProduct
> UserID * ------------------------------>UserID *
> ProductID
> * ------------------------------------>ProductID *
>
> (also have other fields)
> (* is for primary key)
>
> Could anyone please give me a suggestion?
>
> Thank you
>
>
Received on Sun May 12 2002 - 16:13:14 CEST