Question about Computers & Internet

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

7 Answers

I am planning to outsource my payroll to a third party company, can you suggest outsourcing firms other than Southbourne Tax Group?


There are pros and cons in hiring a payroll service. Make sure that you do researching first before deciding whether hiring a third-party company will be beneficial to your business.

I employ Southbourne Tax Group for my tax preparations, all I can say is that they have excellent service. I don't regret working with one of their tax professional.

Mar 02, 2017 | Finance

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 Computers & Internet

1 Answer

I am using an access 97 database and my payroll system didnt open, i linked the tables again and the payroll system opened but i have lost the data i have just input. Can i still recover the files?


i think the database property is read-only. or ur connection to the database is read-only. change it to read-write. the recently feeded data cannot be recovered as it didn't got saved.

Feb 03, 2010 | Computers & Internet

1 Answer

I want to make a minor project baed on java....


Hello,

You can visit below if you want to know more new updates in java programming topics.

1. Java Programming Tutorials
2. Java Programming News

Enjoy and have fun in Java.

Thanks

Aug 02, 2009 | Microsoft Windows XP Professional

1 Answer

Problem is to login in the railway reservation system


Sir,
Check this link 
which software do u using?


Thanks Good Luck
Appreciate to rate as "Fixya"

Mar 26, 2009 | Computers & Internet

1 Answer

Regarding intranet chat system


so first you tell wt problm you have in ur projrct

Mar 13, 2009 | Computers & Internet

1 Answer

Project on student attendence.


Hi Radhika,
I can help you in making project, simply wat you have to do is :-
--- try to create Structure chart of the system
--- Try to create DFD
--- Try to create ERD for the system
send it to me at ali_zulfikar@yahoo.com
having problems in all this pl call me at 9899780221

Thanks

Zulfikar Ali

Jan 27, 2009 | Microsoft Windows XP Professional

1 Answer

About antivirus project


Not the answer to your problem but an opinion by myself.Most viruses that are any good begin by shutting down your virus protector and your system restore. I personaly found that a program called deep freeze which is used to work on building viruses was the best course of action against getting one. But as i stated its my opinion.

Dec 05, 2008 | Computers & Internet

1 Answer

Payroll System


Well as it is a school project,, here
www.planetsourcecode.com

they have a lot of source code to do different things as well as completed programs, you can take a look there you may find stuff to give you ideas and examples of how to do things if you get stuck..

Please the people was kind to upload their stuff for free, please dont copy their work as say it is yours, they allow you to use it to make your own stuff better or to tech you how to do stuff. If you see something you like then please use it but modify it as well. If you need anymore specific help let me know ..

Jan 08, 2008 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

831 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...