Re: Newbie question about db normalization theory: redundant keys OK?
Date: Sun, 16 Dec 2007 22:00:09 -0000
> This makes my student number 7613861 artifical?
> This makes my employee number 644923 artificial?
> One is used by my university, the other by my employer. They may be
> arbitrarily assigned, but they are unique and indicate me alone.
> No need to make up GUIDs or whatever, the real world has been aware of the
> reuirement to uniquely identify humans by other than their names for a
> long time (since somewhere near the beginning of written record keeping I
> suspect) and these are generally adequate.
> (tiring of the wanking so pervasive in this group)
>> My choice is b) and it's what I've been talking about.
Exactly what I've been trying to get across!
A pitty celko and bob bador don't think so....
-- Tony Rogerson, SQL Server MVP http://sqlblogcasts.com/blogs/tonyrogerson [Ramblings from the field from a SQL consultant] http://sqlserverfaq.com [UK SQL User Community]Received on Sun Dec 16 2007 - 23:00:09 CET