Mini-case – Collaborative Auditing Incorporated Collaborative Auditing Incorpora
ID: 3755450 • Letter: M
Question
Mini-case – Collaborative Auditing Incorporated
Collaborative Auditing Incorporated (CAI), a public accounting firm, provides internal auditing services. When a client company contracts with CAI, some CAI auditors pair with client company employees to form two-person auditing teams. Teams complete auditing tasks. During a contract, a manager assigns tasks to each of the two-per son teams. Teams must complete many such tasks before CAI can issue a final risk assessment.
1.An account rep worries that client employees with more experience than auditors might unduly influence the findings. Can she list all teams for a given client where the client employee’s hire date is earlier than the auditor's?
Mark One: (Yes) (No) (Not Possible to tell from this diagram)
CLIENT AUDITOR First Name Last Name Hire Date Cell Phone # CLIENT EMPLOYEE Works For Company Name 01.1City First Name Address Last Name Cell Phone # Hire date Job Title State Phone Contract Begin Date Contract End Date Contract Price TEAM Team Name Date Created ASSIGNMENT Priority Due Date Completion Date Finding Finding Severity Recommendation ACCOUNT REP First Name Last Name Hire Date Commission TASK Contracts with Description Risk LevelExplanation / Answer
She cannot list all teams for a given client where the client employee’s hire date is earlier than the auditor's. Team table contains the details of Auditors and Client employees. From this table we can't get the name of employees, the name of employees would have enabled us to get the Hire Date from Auditor and Current Employee table. Team name and Date Created attributes in Team table doesb't give any help find employe's Hire Date. Also the Assignement table and Task table aren't useful to get any information related to Hire Date.