Question about Compilers & Programming Tools

3 Answers

Payroll system in DBMS. I don't know what data is to be taken.

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.

Posted by on

  • kk_champ2005 Apr 09, 2009

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

×

3 Answers

  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Contributor
  • 40 Answers

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.

Posted on Dec 28, 2008

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Create a database of city public school.in this we manage the data about students,classes,courses and staff.give me complete ERdiagram and also normalization form

Posted on Jan 02, 2010

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

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..

Posted on Dec 04, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

About projects


Video Rental Library
Library Management
Hospital Management
Hotel Management
are some of the common topics. YOu can opt for Video Rental Library. First identify factors that involve in Video Library. Prepare a note on how the video rental works. Then develop a sketch of what forms you will need on a peice of paper. Identify what databases you will need. Then proceed.

Jul 19, 2010 | Microsoft Compilers & Programming Tools

2 Answers

DFT technique in image steganography


Just do a search in your favorite search engine for 'steganography dft' and you should get several thousand results that cover the theory, the math involved, etc. Bing returned 3,380 valid results.

Jul 26, 2009 | Compilers & Programming Tools

1 Answer

Vb project topics for diploma final year student


Hi,
Well there are lots of topics on which you can develop projects.
Some nicest topics are:-
1.College Intranet
2.Any social website
3.Any website playing videos.
4.A small compiler
5.Voice recogonising software for ecommerce etc

Thanks!

Jul 19, 2009 | Compilers & Programming Tools

3 Answers

Java source code for hospital management system


Sir,
I need a project of Hospital management system. Since client needs project in very sort time so plz send same type of project at my email id that can help me out in database design or full code in a professional way .. Please be in touch with me.
regards Varun kumar
email : er.varunsoft@gmail.com

Apr 18, 2009 | Compilers & Programming Tools

1 Answer

What is visual basic practical 6.0


Read the HOW TO section in the Help File of the program, or search the net for "what is visual basic practical"

Apr 02, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

Regarding intranet chat system


so first you tell wt problm you have in ur projrct

Mar 13, 2009 | Compilers & Programming Tools

1 Answer

I need free download for payroll system software


try btjunkie. this site does not host any files but is a forum and listing for torrents. downloading and using these files may infrindge copyright laws. be careful.

Mar 10, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

I don't know how to print payslip in my payroll system.


i dont know to how to create the program in payroll system..

Feb 19, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

Project topic needed


How about developing a bank, with different types of user profiles and authorization, check accounts, operations, log of operations... much to go there. you can have it simple, and then add more and more.
hope it helps

Jan 23, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

Project on hospital manegement in c++


Wow that is a lot of information... All i know it is a programming project for a hospital and I don't even know what it is going to do or what OS it will be running on? Let me guess you want me to write the code for you? Maybe if I had a little more information.

Dec 10, 2008 | Compilers & Programming Tools

Not finding what you are looking for?
Compilers & Programming Tools Logo

Related Topics:

830 people viewed this question

Ask a Question

Usually answered in minutes!

Top Compilers & Programming Tools Experts

Robin Hill
Robin Hill

Level 3 Expert

1251 Answers

Fred Block
Fred Block

Level 2 Expert

289 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18304 Answers

Are you a Compiler and Programming Tool Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...