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

×

Ad

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

Ad
  • 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

Ad
  • 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 there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

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

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

2 Answers

Information about given listed projects


A very good place to start your research will be the newsgroup sci.crypt for learning about security issues. Security is not something you can learn in a couple of days though...

Best of luck

Aug 16, 2009 | Microsoft Windows XP Professional

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

DAO in vb


Nice try. Find an upper-class student to give you one-on-one tutoring with your homework.

Apr 16, 2009 | Computers & Internet

1 Answer

Application and example of relationship in access


Relationships

After you've set up multiple tables in your Microsoft Access database, you need a way of telling Access how to bring that information back together again. The first step in this process is to define relationships between your tables. After you've done that, you can create queries, forms, and reports to display information from several tables at once.

A relationship works by matching data in key fields - usually a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a foreign key in the other table. For example, teachers can be associated with the students they're responsible for by creating a relationship between the teacher's table and the student's table using the TeacherID fields.

Having met the criteria above, follow these steps for creating relationships between tables.
  1. In the database window view, at the top, click on Tools ---> Relationships
  2. Select the Tables you want to link together, by clicking on them and selecting the Add Button
  3. Drag the primary key of the Parent table (Teacher in this case), and drop it into the same field in the Child table (Student in this case.)
    relationshipdrag.jpg
  4. Select Enforce Referential Integrity
    refintegrity.jpg
    • When the Cascade Update Related Fields check box is set, changing a primary key value in the primary table automatically updates the matching value in all related records.
    • When the Cascade Delete Related Records check box is set, deleting a record in the primary table deletes any related records in the related table
  5. Click Create and Save the Relationship

Apr 09, 2009 | Microsoft Computers & Internet

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

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

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

Related Topics:

838 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Alun Cox

Level 3 Expert

2678 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

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

Answer questions

Manuals & User Guides

Loading...