C# .NET - Leave Tracking System - Asked By abinav shankar on 14-Dec-11 01:50 AM


I want to design a leave tracking system as part of my project can anyone help me with the database design and the modules?

Jitendra Faye replied to abinav shankar on 14-Dec-11 01:59 AM
Following are some of the features that the leave management system should have, once a staff joins the organization, an account should be created by HR in the intranet and appropriate leaves should be added.

1. A person should be able to

• login to the system through the first page of the application

• change the password after logging into the system

• see his/her eligibility details (like how many days of leave he/she is eligible for etc)

• query the leave balance

• see his/her leave history since the time he/she joined the company/college

• apply for leave, specifying the from and to dates, reason for taking leave, address for communication while on leave and his/her superior’s email id

• see his/her current leave applications and the leave applications that are submitted to him/her for approval or cancellation

• approve/reject the leave applications that are submitted to him/her

• withdraw his/her leave application (which has not been approved yet)

• cancel his/her leave (which has been already approved). This will need to be approved by his/her Superior

• get help about the leave system on how to use the different features of the system

2. As soon as a leave application /cancellation request /withdrawal /approval /rejection /password-change is made by the person, an automatic email should be sent to the person and his superior giving details about the action

3. The number of days of leave (as per the assumed leave policy) should be automatically credited to everybody and a notification regarding the same be sent to them automatically

4. An automatic leave-approval facility for leave applications which are older than 2 weeks should be there. Notification about the automatic leave approval should be sent to the person as well as his superior

5. A summary report of the leave details of his/her sub-ordinates should be sent to every manager periodically

6. A calendar giving the public holidays of the organization should be available on the system

Hope this will help you.