Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

create the payroll system For the scope of this assignment, you only have to create the entity relationship design for the payroll database, which is

create the payroll system
For the scope of this assignment, you only have to create the entity relationship design for the payroll
database, which is a component of the payroll application you will be creating;
Some data points:
The payroll period is biweekly, meaning employees get paid every two weeks or 26 times per
month (52 weeks per year /2).
For simplicity, you can assume that all the employees are in the same state.
You calculate the salary by using the formula below:
Gross Salary =(hourly pay rate * hours worked)
Pre-tax deductions =(401k contributions + health insurance cost + life insurance
cost + Social Security tax)
Post-tax deductions =( Federal Tax + State Tax + City Tax )
Net Salary = Gross Salary -(Pre-tax deduction + Post-tax deductions)
You start thinking about what data points you need, and here are some but feel free to use your
imagination and add as needed.
First name
Middle name
Last Name
Department
Job Title Hourly Salary Rate
Number of worked hours
Federal tax rate
State tax rate
City Tax
Social security tax
Net Salary
401K contributions
Health insurance deduction
Life insurance deduction
Your submission will be a screenshot of your entity relationship diagram (ERD) showing the relationships
and keys

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases Organizing Information Digital And Information Literacy

Authors: Greg Roza

1st Edition

1448805929, 978-1448805921

More Books

Students also viewed these Databases questions

Question

How to Estimate a Population Mean or Proportion

Answered: 1 week ago

Question

State the uses of job description.

Answered: 1 week ago

Question

Explain in detail the different methods of performance appraisal .

Answered: 1 week ago