add optimistic locking to employees, departments, and locations