Re: Examples for one-to-one associations?

hoodwill wrote:
> Examples of one to ones:
>
> 1) Spouse
>
> 2) Health Policies (for Employees' Company-Sponsored Plan)

So say you but what people want to record is what decides what 'associations' are reflected by a db. Since the atom was split it has been questionable whether any such associations could be innate. Some people want to believe a person has one soul, others think some people have no soul and they will never agree on a common context unless they agree to take souls out of discussion which may be a first step toward mastering abstraction. It may be natural but it's a mistake, also impractical, to yearn for a reality that reflects technology. Context of a db overrules such willfulness and mysticism, those must be put aside when using a db (admittedly this rarely happens which must be part of the reason why there is so much confusion and abuse of mechanical systems and why personal nuances, spiritual or otherwise are usually out-of-scope). In the relational world, what some call 'business rules', others call constraints and others call predicates are the only reliable source of such context, even though some experts will persist in saying for example that zero has special meaning compared to other numbers at the same time as they insist on including it in a number domain.

It's really a waste of time to argue about associations. It might be more profitable to examine the motives for the popularization of the association concept so many years ago, which I think involved nothing more important than searching for machine analogies that made implementation obvious, not necessarily perfect capture of human wishes. Received on Sun Jun 06 2010 - 18:06:23 CEST