In the HR data model, which attributes are present in Payroll?

• A. emp_id, hire_date, department, status.
• B. pay_id, emp_id (foreign key), salary, pay_period, tax.
• C. pay_id, job_id, tax, title.
• D. job_id, salary, department, tax.

Answer: (D)

Payroll focuses on the numbers and classifications needed to calculate compensation and withholdings, while tying that financial data to the employee’s organizational context. The best-fit set of attributes includes job_id, salary, department, and tax. The job_id links payroll to the specific role and its pay scale, ensuring the right salary is applied. Salary is the core compensation figure that payroll must process. Department provides the cost center context for budgeting and reporting, and tax captures the withholdings that must be deducted from pay.

Other options lean away from these core payroll elements. One set includes attributes like hire_date or status, which belong to the employee lifecycle rather than payroll calculations. Another option omits salary or mixes in non-payroll fields such as title, which is a job-related attribute rather than a payroll data point. A final option includes pay_period but also lacks the essential departmental and job-based context.

So, the combination of job_id, salary, department, and tax best represents what the Payroll area needs in this HR data model.