I have come across a complex scenario where I have to design a database for a in-house project of my company. The project is claim management system where employee can
submit their different claims i.g medical, traveling etc. But this claims will also have to get approval from specific managers before they are accepted. Here the heirarchy of
the approval managers can b different based on the designation of the employee and type of the claim. Lets suppose for a medical claim if employee designation is Senior Software
Engineer then their claim gets first approved by Team Lead then from Manager. For the same designation for a traveling allowance claim will directly approved by Director. If
designation is manager then for his medical claim, he will get directly approval from Director. So far, I have come across following tables,
ClaimTypes(ClaimId, Claim)
EmployeeDesignation(Id, Designation, Manager(parentId))
ClaimApprovalLevel(Id, ClaimId, designationId, Approvallevel, approvalAuthority)
But here I am confused that what if a same employee of same designation need approval from two different managers ? Is my solution viable if there has to be added further heirarchies of managers in future ?