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: Lee Newton <spam_at_ntlworld.com>
Date: Sun, 12 May 2002 11:56:21 +0100
Message-ID: <dTrD8.622$eK4.63314@newsfep1-win.server.ntli.net>

> 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?

Two options here.

  1. Remove "tblShoppingCart" (it's not really needed).
  2. or create a new field in "tblShoppingCart" called "CartID" (PK). Remove "UserID" from "tblCartDetail" and create a field called "CartID" (FK).
Received on Sun May 12 2002 - 05:56:21 CDT

Original text of this message

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