Re: Negative Numbers in "Identity" or" Autonumber" fields

On Mar 20, 6:13 pm, paul c <toledobythe..._at_oohay.ac> wrote:
> -CELKO- wrote:
> > ...
> > (2) Two relations may have user-controlled keys defined on distinct
> > domains (e.g. one uses social security, while the other uses employee
> > serial numbers) and yet the entities denoted are the same.
> > ...
>
> People have been questioning that paper for years. Not to discount it,
> here's my first question: what if the same person was an employee of
> both companies before they merged? Is he now two employees?
>
> p

In the books about DB design, I am pretty sure that you will not find something like: DB design using the merge method. I mean if two companies are merged it not imply that new database should be merge of the two databases. There are some basic steps regarding DB design for one particular database.

Vladimir Odrljin Received on Wed Mar 21 2007 - 03:50:18 CET