Answered step by step
Verified Expert Solution
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 times per
month weeks per year
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
Pretax deductions k contributions health insurance cost life insurance
cost Social Security tax
Posttax deductions Federal Tax State Tax City Tax
Net Salary Gross Salary Pretax deduction Posttax 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
K 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started