EmpRoles: ID Int, Identity Description NVARCHAR(30)
Employees: ID Up to you: Int, Identity; or Guid is good. Role Int, foreign key to ID in EmpRoles table ... Rest of information.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)