943,969 Members | Top Members by Rank

Ad:
Sep 2nd, 2006
0

Employee Salary Database design.

Expand Post »
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:
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
gurubbsr is offline Offline
1 posts
since Sep 2006
Oct 7th, 2006
0

Re: Employee Salary Database design.

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.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
hdhere is offline Offline
3 posts
since Oct 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Database Design Forum Timeline: database connectivity
Next Thread in Database Design Forum Timeline: DaniWeb Downtime ... all my fault





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC