Re: Help finding natural keys
Date: Tue, 28 Jan 2003 21:43:22 -0000
Message-ID: <b1892p$rok$1_at_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 - 22:43:22 CET