Re: Database Design for Shopping Cart

From: Lee Newton <>
Date: Sun, 12 May 2002 11:56:21 +0100
Message-ID: <dTrD8.622$>

> 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 - 12:56:21 CEST

Original text of this message