• Jeff Moden (11/28/2016)


    RonKyle (11/28/2016)


    You must have successfully identified business keys before.

    So it must be easy for you to show couple of examples (from your experience) where natural keys were just right to identify some entities.

    Can you share those examples with us, please?

    I already have in an earlier comment. Employee numbers as the most obvious.

    Any idea what the breakdown was for such employee "numbers" was? Did they base them on some sort of date and sequence number combination? or ???

    One place I worked used an employee identity number that was based on two things: identifier (two decimal digits) of the component of the company which originally recruited the employee and serial number (4 decimal digits) of recruitment within that component. When I joined that company, the components were called organisations, later they were called divisions, which created no end of confusion (as previously organisations had benn split into divisions) but the personnel guys kept the numbering working just fine, and organised everyone's job title change to fit the new component names, and carried on helping with recruitment and training and so on without any noticeable disruption (that was in the days when personnel departments did useful things, before they became those useless entitities "human resource departments" who were far too important to do anything useful.

    Tom