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