RE: Database architecture...

[Sergio M. [GTI] <se...@gt...>]

Hi Roland,

>>Exemple: I am a business that sells goods. I have a vendor where I buy my
>>goods. What happens when he wants one of my goods??? To do it correct, I
>>would have to put him in the customar-table, but that would be creating...
>>
>>Solution: The solution would be to not take people or companies as being
>>there functions. I mean, a vendor is not really a vendor because he
himself ...

Exceptions will always exist and the rule I use when creating databases is
to satisfy the majority.  I also have clients where a vendor is also a
customer, but the percentage is so small that it is not recommended to have
a large table called companies.  This will add complexity to the appliation.

Never do a major impact to database design to satisfy a minority issue!

My .02 cents!
Sergio