'[PHP3] Database Design'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-general
Subject:    [PHP3] Database Design
From:       "Dean, John" <DEANJX () mail ! aramco ! com ! sa>
Date:       1999-12-05 12:47:03
[Download RAW message or body]

I have a small point that I hope will prompt an active discussion, yet
again. For this example let'd take a look at the Product Orders tables in a
Shopping Cart application. Both Products and Orders have contain IDs but a
single Order can contain many products so how do we achieve uniqueness.
There is a one-to-one reverse association but a one-to-many forward
association. Once you sorted out this problem the next problem is in which
table should the Order Quality be placed. I know the answers to these
problems, what I am leading upto is the necessity for good database design
could save a lot of problems especially if the user is thinking of setting
up an e-commerce site which could lead to legal problems if thing don't
work.
I hope this provokes a good discussion. It is not intended as negative
critisism to those guys who have worked hard at producing OpenSource
Shopping Cart Applications. It intended to help and promote a good design
philosophy
Best Regards
John Dean

[Attachment #3 (text/html)]

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0">
<TITLE>Database Design</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2 FACE="Arial">I have a small point that I hope will prompt \
an active discussion, yet again. For this example let'd take a look at the \
Product Orders tables in a Shopping Cart application. Both Products and \
Orders have contain IDs but a single Order can contain many products so how \
do we achieve uniqueness. There is a one-to-one reverse association but a \
one-to-many forward association. Once you sorted out this problem the next \
problem is in which table should the Order Quality be placed. I know the \
answers to these problems, what I am leading upto is the necessity for good \
database design could save a lot of problems especially if the user is \
thinking of setting up an e-commerce site which could lead to legal \
problems if thing don't work.</FONT></P>

<P><FONT SIZE=2 FACE="Arial">I hope this provokes a good discussion. It is \
not intended as negative critisism to those guys who have worked hard at \
producing OpenSource Shopping Cart Applications. It intended to help and \
promote a good design philosophy</FONT></P>

<P><FONT SIZE=2 FACE="Arial">Best Regards</FONT>
<BR><FONT SIZE=2 FACE="Arial">John Dean</FONT>
</P>

</BODY>
</HTML>



[prev in list] [next in list] [prev in thread] [next in thread]
Configure | About | News | Add a list | Sponsored by KoreLogic