Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Database Design for Shopping Cart

Re: Database Design for Shopping Cart

From: mercer <brock_at_pallettown.net>
Date: Sun, 12 May 2002 10:13:14 -0400
Message-ID: <O6o7U5b#BHA.2312@tkmsftngp04>


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 - 09:13:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US