Employee Salary Database design.

Reply

Join Date: Sep 2006
Posts: 1
Reputation: gurubbsr is an unknown quantity at this point 
Solved Threads: 0
gurubbsr gurubbsr is offline Offline
Newbie Poster

Employee Salary Database design.

 
0
  #1
Sep 2nd, 2006
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:
Reply With Quote Quick reply to this message  
Join Date: Oct 2006
Posts: 3
Reputation: hdhere is an unknown quantity at this point 
Solved Threads: 0
hdhere hdhere is offline Offline
Newbie Poster

Re: Employee Salary Database design.

 
0
  #2
Oct 7th, 2006
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.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC