• Surrogate keys are a great way to keep track of multiple instances of the same entity (product, person, ...). You can add a validFrom and validTo date fields to also know when that instance was in existence. The latest instance will have the validTo be NULL.

    Best

    ----------------------------------------------------