Member Avatar for gurubbsr

I am a developer creating a package for Employee.
Salary Slip maintenance creating problem means I am not getting ideas of create table.

Please help me to create table.

Salary of an Employee has following heads
* Consoldated Amt

* Additional Allowance
* Camp Allowance
* Vechile Allowance
* Servant Allowance
Tax / Reduction
* Profession Tax [ Change according to Govt. Rule ]
* Provident Fund[ Change according to Govt. Rule ]

[ Above * Fields are fixed means employee either get 0 or some amount in a month on these heads.
Below * Fields are optional. ]

Other Allowance
* One or More Allowances are given to an employee depending on satisfaction of an Employer
Bonus
* Yearly
pleaseeeeeeeeeeeeeeeeeeee help me:rolleyes:

  • 2 Contributors
  • 1 Reply
  • 90 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by hdhere
Member Avatar for hdhere

Look into to DB normalization. Standard procedure in design of relational DB tables. Normalization will help to define the assorted tables needed to effectively do the job. You then use the tools provided by the DB to create a table.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.