It's been awhile since I posted this but I believe the second table tEmployeeStatus was used to maintain the status list so statuses could be added from a UI. You don't to have to have that table as the list could be maintained directly in the constraint but of course you lose some flexibility in regards to the above requirements.