Company ALPHA wants to devise an Employee Presence Monitoring System (EPMS) to monitor effective working time of an employee. Apart from details such as Emp_ID, Age, address, contact number etc., each employee will have a special counter. First time an employee enters into the office, the counter is set to 1. From then onwards, each time an employee leaves the office premises for tea break or lunch break, and enters back this id is incremented. You can figure out that when this id is odd on a day, he is in the office premises and even when he is out. EPMS also records the number of breaks and total duration of the break in a dayThe organization uses this data to perform the following analytics:
How many employees came today?
Did a particular employee come today?
How often did an employee enter into the office?
Which employee moves out of office most number of times?
Name of the employees who are all out for a particular time period
Who all came within a range of IDs, and how often they entered?
The solution was posted here:
https://codeshare.io/RbyWKoa
Comments
Leave a comment