Design database (tables) for below scenario (to Calculate the salary of employees )
Organization has various ranges of products. In organization, CEO is the first employee, under CEO 4 managers are there, one manager is for sales, under sales manager 5 assistant managers are there, under each assistant manager team leaders are there, under each team leader sales executives are there.
Salary components are fixed salary + incentives amount + quarter bonus +birthday gift/bonus. Sales executive’s incentive depends on total sales in that month. Assistant managers are eligible for quarter bonus depending on his team performance(total sales). All permanent employees are eligible for birthday gift/bonus.
Please suggest database design to calculate the salary of employees. ( Database diagrammatic approach is also appreciated).