Programming Tools
Problem for Programming Tools
Generic problem for all Programming Tools

Payroll system in DBMS. I don't know wha...




By lucky99thaku on Dec 25, 2008

" "
I'm a student of bca 3rd. I'm preparing a project on payroll system in DBMS. but i don't know what data is to be taken to create tables, and other records in DBMS.

Same Problem

Apr 09, 2009

-   payroll system in DBMS. I don't know what data is to be taken -   kk_champ2005

Best Solution

posted on Dec 28, 2008
Very Helpful)

hondaman900

Rank: Wiz 
Rating: 86%, 22 votes
Firstly you need to determine/state whether you are using a database application, such as Access, MtSQL or MS SQL and programming them to do create this application, or are you using a programming development tool such as Visual Studio, ASP.NET, PHP or the like, as the solution and guidance will be different for each.
In terms of the data design, you should store the data necessary to identify each employee uniquely and each data point per employee needed to calculate their payroll. You should then store the generic (applys to all employees) such as tax rates, in separate tables and call on it to calculate wages and other paystub data.
For instance, the employee first and last names and tax ID should be a sufficient unique identifier. Create a table for just employees, their names, tax ID, start date, schedule, pay rate, number of deductions, direct bank payment data, etc., and whatever else you decide you need for each employee. You can calculate their wages by multiplying their rate by their schedule and applying the appropriate tax rate and medical/witholding deductions as you go, so calculated data does not need to be stored and consume database space. 
You'll likely need a separate table for common data such as tax rates, one for deductions/witholdings, one for holidays, one for vacation accrual rates, one for medical rates, etc. This data if common to employees does not need to be stored per individual, as that would cause redundant replication of data. If the employees are on an hourly rate, rather than a set salary/wage, then you'll need a table of worked hours per employee, akin to their timesheet data. If you use a timesheet/timecard, the entering and storing only the totals and keeping the physical timesheet for backup records should suffice.
Once you design and populate your database as suggested above, then it's a relatively-simple task of calculating the computed paystub data and storing the salient resulting datapoints for the record.
Consider a reporting application, such as Crystal Reports, for your printing needs, as its far easier to configure Crystal or similar product to format reports, paystubs, checks, etc., than coding these from scratch.
Hope this helps.
Was this helpful?
Yes
No
1 person thought this was helpful

Solution #2

posted on Dec 04, 2009
Not Rated)

poyax_16

Rank: Apprentice 
Rating: 0%, 0 votes
i have a problem of my computer..... my pc attacks and non-curable virus.. says this the proplems indicates many. hides the .exe,bat, system files. i dont know how 2 find them.... can u give me the manual syntax for deletion instead of using anti-virus..
Was this helpful?
Yes
No

Popular Solutions for Programming Tools


Questions and Unsolved Problems for Programming Tools


Answer
where can I get a customer tool disk for a sharp xa-a41s??

Answer
I can not write pictures to CD. It says I don not have a CD in D drive , when I do.

Answer
i need driver fr my cam ez306spca561a

Answer
como manejar microsoft media player desde delphi 7

Answer
When I go into any zylom game now I receive a message from microsoft windows - Internet explorer has... (More)


Didn't find what you were looking for?

Describe your problem:

Select a Category:







Ask our Experts

 

Solve Your Problem Now!
Chat Live with an Expert
Chat Now
Top Programming Tool Experts



Top Computer & Laptop Repairmen

(513) 874-3306
We fix and repair laptop motherboard no video, no...
LaptopOnCall Inc.

(877) 934-6198
Send your laptop to us and we will diagnose the...
A+ Rated Oceanside Computer Sales & Service, LLC


       
Solve Your Problem Now!
Chat Live with an Expert
Chat Now

Insert Link
Insert Image
Insert You-Tube clip
Insert List
Insert List
Spell Check

What is this?



Select