Employee Clock in/out application
-
I am currently working on a project to develop an application which employees will use to clock in, clock out on break, clock in after break, do the same for lunch, and clock out for the end of the day. This application will record time an employee works, calculate regular and over time then prepare a report for HR so employees can get paid. HR is also able to correct any error the employee may had made, e.g. forgot to log out or login. Employees work by shift thus an employee may start working on one date and end on the following date. I was thinking about creating the calculation logic in SQL as a stored procedure but was advised that doing so may not be best idea. I am not sure where to start on this, besides creating the tables needed for the project in SQL. Any sample or advice on this issue will be greatly appreciated.
Skan If you knew it would not compile why didn't you tell me?!?!?!
-
I am currently working on a project to develop an application which employees will use to clock in, clock out on break, clock in after break, do the same for lunch, and clock out for the end of the day. This application will record time an employee works, calculate regular and over time then prepare a report for HR so employees can get paid. HR is also able to correct any error the employee may had made, e.g. forgot to log out or login. Employees work by shift thus an employee may start working on one date and end on the following date. I was thinking about creating the calculation logic in SQL as a stored procedure but was advised that doing so may not be best idea. I am not sure where to start on this, besides creating the tables needed for the project in SQL. Any sample or advice on this issue will be greatly appreciated.
Skan If you knew it would not compile why didn't you tell me?!?!?!
A simple search will reveal a plethora of examples. It's a common homework assignment.
only two letters away from being an asset
-
A simple search will reveal a plethora of examples. It's a common homework assignment.
only two letters away from being an asset
Mark Nischalke wrote:
It's a common homework assignment.
Which is what this would seem to be.
Deja View - the feeling that you've seen this post before.