• you can create composite primary keys such as

    EmployeeMaster - CompanyID, EmployeeMasterID

    PayCode - CompanyID, PayCodeID

    EarningsMiscWrk - CompanyID, EmployeeMasterID, PayCodeID

    Foriegn keys can be created on this table on

    CompanyID, PayCodeId refer to CompanyID, PayCodeId in PayCode table.

    CompanyID, EmployeeMasterID refer to CompanyID, EmployeeMasterID in EmployeeMaster table