Leave Management System

LEAVE MANAGEMENT SYSTEM

1

Leave Management System

Introduction There are many type of leaves which are provide to an employee .Employee can use these leaves according to their necessity. The different types of leaves are:1. PRIVILAGE LEAVE CASUAL LEAVE 2. MATERNITY LEAVE (Only For Ladies) 4. ENCASHMENT LEAVE Generally the leave request and process works are done and managed manually hence leading to the chances of human errors that may create some problems. Thus, a secured and reliable system is required to handle it. Automation of LEAVE, as described above, can lead to error free, secure, reliable and fast Information system. It can assist the staff to concentrate on their other activities rather to concentrate on the record keeping. Thus it will help organization in better utilization of resources. The organization can maintain computerized records without redundant entries. That means that one need not be distracted by information that is not relevant, while being able to reach the information that is relevant much more quickly.

2


Objectives of the Project The basic objective behind developing this project “LEAVE MANGEMENT SYSTEM” is as follows: To keep and manipulate the details of all employees in company.  To generate enquiry of employee on demand.  The main objective of this application is to automate as well as update leave information of the employees.  To handle proper and full information of every leave which have been provide by the organization.  Proper and timely entries can be made so that records always have correct and up to date information about the employees leave.  If any of the organization employee wants to know about his/her leave status it be easier.  To calculate the employee salary with leave and without leave.  The employee on leave, report can be generated by the Organization.  To manipulate leave information of employee for the organization.  To generate reports for management from various modules.

3


Project Category

RDBMS CATEGORY PROJECT The project comes under RDBMS category. The project handles the huge data in company subjected to employee, their leaves detail and salary. The RDBMS is capable of creating storage, keeping date, manipulating data and retrieving data in desired manner.

4


Input to the Project

The Major inputs to the project are…. 1) Employee detail. 2) Detail of leave taken by employees. 3) Leave type that organization provides. 4) Salary detail.

Output of the Project

The major outputs are… 1) Employee Enquiry. 2) Details of employee on leave. 3) Detail of salary of employee. 4) Details of employee not taken leave in a month. 5) Reports from various modules.

5


Analysis

0 LEVELDFD

EMPLOYEE

Request for Leave Issue Leave

LEAVE MANAGEMEN T SYSTEM

Request for Report

MANAGEMENT

Issue Report

DATABASE

6


1 LEVEL DFD (Showing leaves request/issue process)

LEAVE ORDER REQUEST

PROCESS REQUEST LEAVE REQUEST

CHECK LEAVE STATU S

SATAUS LEAVE SATAUS LEAVE

EMPLOYEE DETAILS

EMPLOYEE

LEAVE INFO

EMPLOYEE ISSUE LEAVE

LEAVE ISSUE

REPORT

2nd LEVEL DFD 7 EMPLOYEE

CHECK LEAVE LEAVE TYPE DETAIL

MANAGEMENT

PROC ISSUE Leave Management System ESS LEAV LEAVE REQU E STATUS EST

LEAVE REQUEST

V

STATUS

VALID

LEAVE REQUEST

LEAVE INFO

INVALID CANNOT PROCESS REQUEST

ISSUE LEAVE

MANAGEMENT REPORT

1ST LEVEL DFD 8


(Showing process of salary slip generation) EMPLOYEE

EMPLOYEE DETAIL

PRINT SALAR Y SLIP

LEAVE MANGE R

LEAVE DETAIL

LEAVE DETAIL

MANAGEMENT

SLIP

EMPLOYEE DETAIL

CALCULATED SALARY

REPORT PREAR E LEAVE REPOR T

SALARY DATABASE

REPORT SALARY

SALARY DEPARTMENT REPORT

EMPLOYE E SALARY

CHECK LEAVE

SALARY DETAIL

CALCULAT E SALARY

LEAVE DETAIL

Entity Relational Diagram 9


E_gende r

E_DOB

E_l_name

E_address

E_f_name

E_designat ion E_city

E_id

E_phone

L_type

EMPLOYEE

LEAVE

TAKE S

L_comme nt

E_b_salary

E_departm ent

Edate of joining E_HOD

10

No_of_days__in_month

Commen t Leave Management System

Modules and Description LEAVE TIME ENTERY MODULE This is an administrative module, which feeds the details of all types; leave that organization provides. The module can also manipulate these details. The enquiry about leaves types can also be done by using this module. NEW EMPLOYEE ENTRY MODULE The module is used to make entry of employees which comes to make organization. The module accepts details, validates it and stored the details into database. The module can also update & delete employee information. EMPLOYEE ENQUIRY MODULE The module is used to query the employee data base in various ways, such as enquiry on employee id, name, designation & gender. LEAVE MODULE This is the main module which exhibits the central logic of software .the module is used to process the leave request of employee & assign the leave to the employee. The module keeps tracks of employee on the 11


leave. the module except the leave request & if it’s a valid request then assign the leave to the employee & have the leave details along with employee information for further manipulation. LEAVE ENQUIREY MODULE The module is basically for management of organization. This module provides the details of employee & their leaves in a desire manner. The module can be used to calculate the salary of employee on the basis of his/ her leave. The module looks as an information retrieved module for management. SALARY CALCULATION MODULE This module is used to calculate &pay salary of employee for each month. Before calculating salary the module checks for leave of employee of that month & then separates the leave with pay & without pay. Then calculate the salary & update the database of the salary.

12


Data Structures The proposed System includes the following Tables… TABLE No. - 1 EMPLOYEE TABLE FIELD NAME

DATA TIME

DESCRIPTION

E_id E_f_name

int varchar (30)

E_L_Name

varchar (30)

E_DOB

Date / time

E_Gender E_Add

Char(6) varchar (50)

E_City E_Phone E_Designation

varchar (30) varchar (30) varchar (30)

E_Department

varchar (30)

E_HOD

varchar (30)

E_B_Salary

Float

E_DOJ

Date / Time

Comments

varchar (50)

Primary key First name of the employee Last name of the employee Date of birth of the employee Employee gender Address of the employee Name of employee city Phone no. of employee Designation of employee Department of employee Head of Department of Employee Basic Salary of Employee Date of joining of employee Comments (If ANY)

TABLE No. - 2 13


EMPLOYEE LEAVE FIELD NAME

DATA TYPE

DESCRIPTION

E_id From

int Date / Time

To Type_leave type No_ of_Days Comments

Date / Time Varchar int varchar(50)

Employee i.d. From which Date Employee takes the leave Till which date Type of leave No. of Days If any comment

TABLE No. – 3 LEAVE TABLE FIELD NAME

DATA TYPE

DESCRIPTION

L_Type

varchar(10)

Type of Leave

L_Comment

varchar(50)

Leave Description

No_of_Days

int

Total Leave in a month

TABLE No. - 4 SALARY TABLE

14


FIELD NAME

DATA TYPE

DESCRIPTION

E_id

int

Employee i.d.

Amount_paid

Float

Amount-paid to Employee

P_date

Date / Time

Payment date

TABLE No. - 5 SALARY-DETAILS TABLE

15


16

FEIELD NAME

DATA TYPE

DESCRIPTION

E_id

int

Employee_ID

Month

Date/Time

Date of salary

bs

Float

Basic Salary of Employee

ta

float

TA given

da

float

DA given

hra

float

HRA given

pf

float

PF given

Other

float

Other amount

total

float

Total amount


Process Logic  NEW EMPLOYEE ENTRY MODULE 1. Start

2. Get employee details. 3. Connect to data base. 4. Validate information 5. Insert detail into table 6. Close connection. 7. Stop  EMPLOYEE ENQUIRY 1. Start.

2. Get employee id. 3. Connect to data base. 4. Search records of employee for given id. 5. IF (record found) then { Display details } 17


Else { Write “not found” } 6. Close connection. 7. Stop

 LEAVE DETAIL ENTRY 1. Start.

2. Get leave detail 3. Connect to data base 4. Validate details 5. Insert details to data base. 6. Close connection. 7. Stop

18


 LEAVE REQUEST PROCESS 1. Start.

2. Get employee id. 3. Connect to data base 4. Check for leave in current month 5. If (already taken efficient leave) then { Reject request } Else { Get leave details Update leave database } 6. Close connection. 7. Stop

19


 LEAVE ENQIRY 1. Start

2. Get employee id and month 3. Connect to data base 4. Search leave details of employee for given ID and month 5. If (detail exists) then { Display details of leave } Else { Display “not found” } 6. Close connection. 7. Stop

20


 PAYMENT 1. Start.

2. Get employee id. 3. Connect to data base 4. Find salary information of given employee id. 5. Find the leave taken by given employee id. 6. If (without pay leave found) then { Calculation amount to be deducted into ded } Else { ded=0 } 7. Calculate salary to amount 8. Net salary= amount- ded 9. Update salaries data base 10. Print salary slip 11. Close connection. 12. Stop 21


Limitations of the Project Though the software presents a broad range of options to its users some intricate options could not be covered into it; partly because of logistic and partly due to lack of sophistication. Paucity of time is also major constraint, thus it is not possible to make the software full proof and dynamic. Lack of time also compelled me to ignore some part such as storing old result of the candidate etc. The limitations of the project… The system has not facility for job management. The system does not provide accounting facility. The System can not be used for all types of company; it can be used to satisfy the requirement of a specific company only. The System need Windows environment with having SQL Server 2000 and VB 6.0 configuration to run.

22


Report Generation The system generates the following details… 1) Report of all employees on leave on a given date 2) Reports of employee on leave in a month. 3) Report of available leave for an employee. 4) Reports of issued leave to an employee in a year.

23


Tools/Platforms, Languages Used

Platform Used WINDOWS XP

Back-End Tool SQL Server 2000

Front End Tool Visual Basic 6.0

Reasons for proposing the above tools After looking the available tools and platform, we analyzed that Visual Basic 6.0 and SQL SERVER 2000 would be a better option to develop the proposed system. As Visual Basic provides GUI interface, it was a better option as far as location dependency, exception handling and network traffic was concerned.

24


Thus it was ensured that this project would be technically feasible in Visual Basic 6.0 as Front End and SQL SERVER 2000 as Back End platforms. SQL Server provides an easy and quick way to design and handle database. So SQL Server is chosen as back-end to the project Windows X P is capable of running SQL Server 2000 and provides client/server environment.

Hardware Requirement Processor

Pentium 4 above 1 GHz

RAM

256 MB

Hard Disc

40 GB

Monitor

15 inch color

Mouse, keyboard, printer and other related peripherals

NOTE >> I am not doing this project for any client.

25


Future Scope of the Project

The future scope of this project, LEAVE MANAGEMENT SYSTEM, is very wide. There are many additional features, which are planned to be incorporated during the future enhancements of this project. The Future version of System we can add module to assign job to employee. The Future version of System we can handle accounting in company. The Future version can be improved to provide functionality of working as a general purpose software. The Future version can be improved to run over network.

26


Leave Management System

Recommend Documents