hi i wud like to know how many tables shud i have to create an Employee salary form. i knw i need an Employee details and then i dont knw wat shud i put??? i wud like to make a presence form 2 which will be associated with the employee details form. And a salary details form:
here is
Employee Details form which contains the
EmpID:
Name:
Address:
Tel:
Help plzzzz
If salary is based simply on position, you can have a position table that stores all the positions and salaries related to each position. You can also have a table to track the history of employment so you can track what positions each person used to be at and the salary they had at that time. This set up would require three tables i.e. Employee Details, Position Salary, Employee Position. There would be, in essence, a many-to-many relationship between Employee Details and Position Salary with Employee Position serving as the intermediate table.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.