Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

b . Identify employees who attempted to log in a day or longer ( i . e . , not the same day ) after

b. Identify employees who attempted to log in a day or longer (i.e., not the same day) after they were terminated from working at the organization. The final table should have the following columns in this order: LogEntry, EmployeeName, EndDate, LoginDate and LoginSuccess. Sort the data in ascending order by LogEntry.
Based on this analysis, what recommendations would you make to the company to strengthen its internal controls?
c. The company is closed on several US holidays. The holidays the company is closed included in the data set include Memorial Day (May 30,2022), Independence Day (July 4,2022), Labor Day (September 5,2022) and Thanksgiving Day (November 24,2022). Some employees may still work on these days, but it is expected that far fewer employees will log in.
On these holidays, did the company experience fewer logins than what you would expect? Cleary state your expectation, how many logins occurred on each holiday and anything else of importance that you notice about logins on these four holidays.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these General Management questions