To create a relational database based on the payroll cycle, which types of data should be recorded in the database?
A)Employee information and sales invoices
B)Employee information and number of hours worked
C)Number of hours worked and inventory information
D)Number of hours worked and purchase orders

Question

Quizplus · Accepted Answer

To create a payroll database, it is important to record employee information such as names, social security numbers, addresses, and pay rates. Additionally, the number of hours worked by each employee is necessary to calculate their pay. Therefore, choice B, which includes employee information and number of hours worked, is the best option. The other choices do not include all the necessary data for a payroll database.

To Create a Relational Database Based on the Payroll Cycle