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 $=(401$k 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

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