Re: Help finding natural keys

From: Paul Vernon <paul.vernon_at_ukk.ibmm.comm>
Date: Tue, 28 Jan 2003 21:43:22 -0000
Message-ID: <b1892p$rok$1@sp15at20.hursley.ibm.com>

"Alan Gutierrez" <ajglist_at_izzy.net> wrote in message news:dDxZ9.45922$GX4.1729674_at_news2.east.cox.net... [snip]
> Yes. Actually, most of my tables have a version as part of the surrogate
> key. Something I kept out of the disucssion, since I really was
> interested in natural keys, but the requirement is that a questionnaire
> be reproduced just as it was when it was submitted, so if the patient's
> name was misspelled at admission and subsequent corrected, the admission
> questionnaire should reflect the error.

OK, but be careful about using version numbers if what you are really trying to do is create a temporal database.

> Thank you for your response.

No worries.

Regards
Paul Vernon
Business Intelligence, IBM Global Services Received on Tue Jan 28 2003 - 15:43:22 CST