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_at_newsfep1-win.server.ntli.net>
Date: Sun, 12 May 2002 11:56:21 +0100
Message-ID: <dTrD8.622$eK4.63314_at_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.
- Remove "tblShoppingCart" (it's not really needed).
- or create a new field in "tblShoppingCart" called "CartID" (PK). Remove "UserID" from "tblCartDetail" and create a field called "CartID" (FK).