Re: Oracle NULL vs '' revisited

Tony Rogerson wrote:
>> No. If the key changes, it is a new book! Keys can not change! (Want a >> new car? Get a new licence plate!)

In the state I live in, when you get a new car, you put your old license plates on the new car (assuming you traded your old car in on the new purchase).

> So, a membership database - my user group (sqlserverfaq.com) for
> instance; I only capture this information because it's all I need and by
> law in the UK I can only capture what I need...
>
> Full Name
> Email Address
> Company
> Country of residence
>
> What's the natural key?
>
> Email Address is unique at a point in time.
>
> Are you trying to tell me email address does not change? What happens
> when you move companies? You'd want to update your email address, in
> your data model you aren't allowed to do that so I guess you can't use
> Oracle.

Don't let the politician's in the US hear about this one. Next thing you know, they'll pass a law that says you can take your email address with you...similar to the law for cell phone numbers.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com