13. The company wishes to add more data for human resources, such as tax withholding, benefits selected, and benefit payments by the employees and by the company. Research common methods of handling this type of data and define the required tables.
Many possible options.
Employee(EmployeeID, Withholding Amount, Exemptions, BenefitValue etc.)
Benefits(BenefitID, Name, Cost, etc.) Assumes that all employees pay the same price for a benefit, or they are listed separately.
BenefitChoice(EmployeeID, BenefitID, DateChosen, Price, etc.)
Payroll(PayrollID, EmployeeID, PayDate, PayPeriod, Amount, FederalTax, StateTax, FICA, etc.)