Thanks to all for you help and time.
After reading to replies, I think that perhaps a clean way of dealing
with individual and company customers in a single table could be to
leave them out of the "parties" tree altogether and relate them to
the "parties" table without a generalization hierarchy
Thanks to all for you help and time.
After reading to replies, I think that perhaps a clean way of dealing
with individual and company customers in a single table could be to
leave them out of the "parties" tree altogether and relate them to
the "parties" table without a generalization hierarchy
Alberto,
Persons and companies are distinctive entities, yes. Treating either as
if it were a subspecies of the other leads one into absurdities. Either
may be a customer, but neither need be. You haven't described the
problem context. Conceivably one or the other could also be a
contractor,
[EMAIL PROTECTED] wrote on 07/07/2005 01:57:33 PM:
> Dear Shawn,
> Thanks for your reply.
> I find that "individuals" and "companies" each have attributes that
> are completely irrelevant to the other. E.g. "individuals" have sex
> and language (so e-mail can be sent to them as "Dear Sir" or "De
Dear Shawn,
Thanks for your reply.
I find that "individuals" and "companies" each have attributes that
are completely irrelevant to the other. E.g. "individuals" have sex
and language (so e-mail can be sent to them as "Dear Sir" or "Dear
Madam" in both English and Spanish). The only time they ha
Dear Shawn,
Thanks for your reply.
I find that "individuals" and "companies" each have attributes that
are completely irrelevant to the other. E.g. "individuals" have sex
and language (so e-mail can be sent to them as "Dear Sir" or "Dear
Madam" in both English and Spanish). The only time they ha
[EMAIL PROTECTED] wrote on 07/07/2005 11:22:52 AM:
> Dear list:
> I am preparing an entity relationship diagram and encountered the
> following problem:
> The entity "individual" has the attributes firstname, lastname.
> The entity "company" has the attributes name, companytype.
> Now I wish to i
Dear list:
I am preparing an entity relationship diagram and encountered the
following problem:
The entity "individual" has the attributes firstname, lastname.
The entity "company" has the attributes name, companytype.
Now I wish to include the subtype "customer" with the attributes
taxid, billin
