Hi Jeff,
If you visit my homepage at:
www.geocities.com/hisiomara
click "Tutorials" and select the first item "Team5.com an ecommerce sample"
you will be able to see the ERD diagram that attends your ecommerce demand.
Actually will will be able to see much more.
The design is there,and I will post the codes after. Although I implemented
in Oracle,the design is neutral and can be implemented in any database.
Please let me know your opinion about it, I do appreciate it.
Take care
Sio
PS: I would like to invite everybody to go there. This is a site intended to
show my skills but I also share good stuffs with everybody.
>From: "Jeff Jones" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Design question
>Date: Mon, 18 Jun 2001 14:00:29 -0500
>
>I have a design problem I was hoping some of you could help me out with. I
>am writing a shopping
>cart system (as if there wasn't enough already) and I have one problem that
>has me stumped.
>
>A person can order more than one item of course. So let's say they order a
>kite and some string.
>Both of these have product numbers, and the overall order has an order
>number. I am trying to
>figure out how to design a table ( or tables ) so I can keep track of the
>different products that
>are ordered during one order. I need to keep track of the product number,
>quantity, and price
>for that product. For instance:
>
>Order # Products
>------------- ------------------
>11111 222 : Qty 1: 12.00 # 333 : Qty 2 : 14.00
>
>That is order number 11111 and that person ordered one of product # 222 @
>12.00 and 2 of product # 333 @14.00.
>
>I would appreciate any assistance any of you might be able to offer. If I
>wasn't clear enough, let
>me know and I will try and explain it better.
>
>Thanks.
>
>Jeff Jones
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
