If an employee changes badge number, a new row has to be inserted for him with the new badge no and new issued date. The old badge should not be overwritten or deleted.
An existing badge number may be re-assigned to another employee provided that the previous employee has left.