Draw relationship diagram showing files needed to verify that all employees were paid the correct amount and produce a report showing total pay by department number.

- Identify the primary and foreign keys to each table.

- List necessary tables and field names required to determine if all employees were paid the correct amount; and to produce a summary of total pay by department number

Possible data files are

- Department: lists the department number, position number and employee number for each employee

- Employee: lists the name, address, and employee number of all active employees

- Pay: lists the employee number and gross pay for the current pay period

- Pay rate: lists the position number and the current gross pay per period for each position.