actually, no, Shop, Employee, and Customer are not distinct.
in your instance they are the same type of entry.
don't distinguish them by tables, rather use a column to hold some sort
of an ID for each type.
of course you'll end up with a table with many columns, and many of
them will be null depe
Hi Miguel,
Thanks for the reply.
the non-customer is actually a Shop, so Employee, Customer and Shop are
distinct enough to have their own tables. Now they all have an Address, and
the problem is how do I allow multiple addresses for each these 'people'
(without using
a lookup table)
tony
The schema of your table is wrong, is you do bnormalize it you will find out
that you need two tables for this approach.
One table for your people and another one for the n addresses of your
people.
If you keep your current schema, you will have as many rows for one person
as many addresses for t
Dianne Mead wrote:
Hi,
I know this is the probably the wrong list for this question, but I'm a bit
desperate as my hosting company has disabled PEAR on the server, and I was
using it extensively on more than one website... suddenly my weekend looks
like a coding nightmare. The hosting service repo
I know this is the probably the wrong list for this question, but I'm a bit
desperate as my hosting company has disabled PEAR on the server, and I was
using it extensively on more than one website... suddenly my weekend looks
like a coding nightmare. The hosting service reports a security issue, b
Hi all,
I have the following tables
EmployeeCustomernon-CustomerAddress
=======
pkey pkeypkey
pkey
number type type
...
Hi,
I know this is the probably the wrong list for this question, but I'm a bit
desperate as my hosting company has disabled PEAR on the server, and I was
using it extensively on more than one website... suddenly my weekend looks
like a coding nightmare. The hosting service reports a security iss
The --with-oracle option is a long deprecated interface to Oracle
and no-one has updated the configure script to work with Oracle 10g.
Can you use the new --with-oci8 option? Otherwise you'll need to
update ext/oracle/config.m4. The code in ext/oci8/config.m4 may help.
With either configure optio