Although database design is not a skill required to learn SQL$,$ successful SQL programming highly

depends on database design, and if you become a database software engineer, for sure you will need to

do database design. During my career, I have seen the good, the bad, and the ugly, and my goal is for you

to be able to identify that and only produce good design. I recommend watching this video about

normalization before starting this task.

You recently got a job at REI, a startup sport outdoors retail, as a Database Software Engineer; you are

super happy, excited, and nervous at the same time; you need to be able to perform at the same level as

your co$-$workers; your first assignment is to create the payroll system for the company. For this, you

know that you first need a database to capture$/$store the data, and after that, you will create the user

interface $($UI$)$ along with the code needed to process the calculations needed.

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; many freeware applications could help you to produce the model, but the easy one would be

to use something like Windows Paint, Google Draw, or if you want something more professional you can

adventure with DrawSQL.$$ 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