A Project Report On

EMPLOYEE LEAVE MANAGEMENT SYSTEM

Submitted To
SAVITRIBAI PHULE PUNE UNIVERSITY
BY
MR .NIKAM ATHARVA SHIVAJI
UNDER THE GUIDENCE OF
PROF.CHAITALI SHINDE
DEPARTMENT OF BBA(COMPUTER APPLICATION)
ACADMIC YEAR
2023 – 2024

1
 PANCHAVATI COLLEGE OF MANAGEMENT
& COMPUTER SCIENCE, PANCHAVATI, NASHIK
CERTIFICATE

This Is Certify that

MR :- NIKAM ATHARVA SHIVAJI

Student of S. Y BBA(CA) of this College For the year 2023 - 2024 He/she has
undertaken and completed the project work as require by the rules of the SAVITRIBAI
PHULE PUNE UNIVERSITY.
He/she has completed his/her project work assignment of the

Assignment Topics

EMPLOYEE LEAVE MANAGEMENT SYSTEM

Project Guide HOD

(Prof.Chaitali Shinde) (Prof. Dipak Dandwate)

External Examiner Internal Examiner

Place : Nashik Date: / /
ACKNOWLEDGEMENT
2
 This project work is one of the course allowed by SAVITRAIBAI
PHULE PUNE UNIVERSITY to BBA(CA) student. It was really an excellent
and wonderful experience to work on this project. I take the opportunity to
extend out my heart full gratitude to all those people without whose support and
co-operating, would not have been able to bring out my project to successful
conclusion.
Firstly I would like to thank Prof. Chaitali Shinde for constructive
suggestion and timely help at all stages of the development of this project and
also for his reliance and useful suggestion to improve the quality of work.
I especially like to thanks to Prof. Deepak Dandwate for giving me the
chance to complete my project at their cloth shop and also for necessary and
moral support throughout the span of my project.
I am also thankful to my friends, known and unknown who helped me in
completion of this project.

INDEX
Sr.No Title Page NO.

3
 1. Problem Definition. 5

2. Existing System. 6

3. Proposed System. 7

4. Requirement Analysis 8

5. Scope of the system 9

6. Feasibility study 10

7. ERD. 11

8. UML Diagrams. 12-16

9. Data Dictionary. 17-18

10. Sample I/O Screen. 19-23

11. Report 24

12. 25
Advantages And Limitation
13. Conclusion 26

14. 27
Future Enhancment
15. 28
Bibliography

Problem Definition

In any organization, there are manual records of the leaves

claimed by the employees. Which leads to a lot
4
 of issues like overlapping of leaves among the employees,
improper deduction in the salary, loss of records, etc. There is
no such facility available to manage this problem.
So, to overcome these issues it is essential to implement an
automated system. The Employee leave management system is
designed in order to deal with these issues and maintain proper
records of the leaves and deduct the salary accordingly. The
entire system is managed by 1 admin. Any employee can
request for leave & the decision is taken by the admin whether
to grant the leave or not.

Existing System

As of today’s technology, there are basic application which

handle only the records of the leaves. The deduction in salary has to
be done manually by the admin. It can also lead to errors as the
number of paid leaves are also required to be considered. The existing
5
systems are time consuming in case of human errors and are less
reliable.
Also it becomes easier for the admin to avoid the overlapping of
the leaves and grant the leaves accordingly.

Proposed System

This system is meant to manage the process of leave

management effectively. It has admin login where all the actions
such as accepting/declining any leave request, adding a
department; adding an user, removing users, etc can be

6
performed. In the employee login, employee can view his/her
leave application history, salary deduction, etc.
In this way, leave management becomes a lot more easier
and convenient for any organization.

Requirement Analysis

Software requirement :-
Front end : PHP 5.50 or above.
Back end : MySQL 5.5 or above.
Operating system : Windows(7 or further).
Other requirement : Apache server, XAMPP,WAMPP.

7
 Hardware requirement :-
Processor : Intel core i5.
Hard disk : 8GB hard disk or above.
Ram : 256MB Ram or above.

Scope of the system

This system can be used for any type of institute, organization,

company, etc. It makes sure that the management of leave
applications goes on with ease for both the employee as well as the
administration. It eliminates the errors and gives accurate deduction in
the salary as per the requirement.

8
 Feasibility Study

 Operational Feasibility: -
It is more of a user friendly system. The easy to use mechanism
and effective screen designs would be enough for users to accept new
system with ease. The system won’t find any difficulty to migrate to any

9
 new place. Also the system has an excellent GVI which the user can be
engrossed in.
Hence, the system is operationally feasible.

 Technical Feasibility: -
The project is designed with the use of available resources. There
is no need to have any supporting software. The requirement for
operating system is windows (any version). The system provided.
Thus, the technical requirements are fulfilled effectively. Hence,
the system is technically feasible.

 Economical Feasibility: -
The system is developed using pre-existing resources which are
easily available. It is sustainable economically as there is no need to add
any extra software. There is very basic hardware requirement which
minimizes the cost. This system is worth an investment.
Thus, system is economically feasible.

E-R Diagram

10
 UML Diagrams

1) Class Diagram:-

11
Company department
+cid +did
+cname 1 * +dname
+cadd +#dcode *
+accept() +detinfo
+display() +disp()
Maintains Maintains
company records department record

Leaves Admin
#lno +aid
+to +aname
+from
#grant() +filldetails()
#decline() +dispdetails
Maintains leaves Maintains admin
records records

* 1

1 *

1 *
Employee type
#eid +tid
#ename #tname
#eadd #dest
+empinfo() +list()
+disp() +limit()
Maintains Maintains leave
12
employee records type records
 2) Use case diagram:-

Adds new
empolyee

Adds
department
leave type
empolyee

(Generalisation) Applies for

leave

maternity sick

Verifies
leave details
of the
employee

<employee>
<admin>
sick sick

sick

Grants/does
not grants
leave

Deducts
salary as
per person

13
 3) Sequence Diagram :-

abc:employee ELMS xyz:admin

Registers new employee

Adds new department/leave type

Applies for leave

Notifies about the leave

Grant/does not grants leave

Notifies about the approval/disapproval

Deducts the salary Displays the reduced salary

14
 4) Activity Diagram :-

Enter id and Enter the id and

password password

Verify Verify details

details

Show user Show admin

profile dashboard

View Grant/
Update Change Apply Add Add Add
leave decline the
information password leaves department employee leave type leave
history

15
 Logout Logout

5) Collaboration diagram:-

16
 Data Dictionary

1) Tblcomany:-
Column name Data type Size Constraint
C_no Integer 5 Primary key
C_name Varchar 30 Not null
C_add Varchar 30 Not null

2) Tbladmin:-
Column name Data type Size Constraint
A_id Integer 5 Primary key
A_name Varchar 30 Not null
A_add Varchar 30 Not null

3) Tbldepartment:-
Column name Data type Size Constraint
D_id Integer 5 Primary key
D_name Varchar 30 Not null
D_code Varchar 30 Not null

17
C_no Integer 5 Foreign key
A_id Integer 5 Foreign key

4) Tblleaves:-
Column name Data type Size Constraint
I_no Integer 5 Primary key
From Date Date - Not null
Days Integer 2 Not null
Desc Varchar 100 -
A_id Integer 5 Foreign key

5) Tblleavetype:-
Column name Data type Size Constraint
D_id Integer 5 Primary key
D_name Varchar 30 Not null
D_code Varchar 30 Not null
C_no Integer 5 Foreign key
A_id Integer 5 Foreign key

6) Tblemployee:-
Column name Data type Size Constraint
E_id Integer 5 Primary key
E_name Varchar 20 Not null

18
E_add Varchar 80 Not null
E_code Varchar 8 Unique

7) Tbleave_emp:-
Column name Data type Size Constraint
I_no Integer 5 Foreign key
E_no Integer 5 Foreign key
Status Boolean - Not null

Source I/O Screens

Admin Module:-

I. Admin login

II. Admin Dashboard

19
III. Change password

IV. Add department

20
V. Admin (Register New Employee)

VI. Leave management

21
Employee Module :-

I. Employee login

II. Employee (Apply for leave)

22
III. Employee information update

IV. Employee (leave history)

23
 rr

Report
Abstract:-

Abstract Employee Management System Project is an essentially software designed to

keep track of employee information in any company. It stores data such as their employees'
personal information. The goal of "Employee Management System" is to create a work center
scheduling system. Scheduling is a technology that makes the process of informing activities
and notifications in the company where it is implemented simple and even online. The
employee management system project gives managers a better idea of their employees and
helps them plan and manage their work hours in order to cut costs and boost productivity. It
gives appropriate directions and supervisions for employees. It also secures and manages

24
information that are important to the employees including personal and work-related
information.

Modules:-

• Employee Information Management: This module provides a consolidated database for

application tracking, employee demographics, compensation and benefit options, time
tracking, and more. It's also the central location for all of your personnel data, including the
most up-to-date statistics on your organization's hiring and retention patterns.

• Employee Schedule Monitoring: Employee schedule monitoring entails the use of a variety
of workplace surveillance techniques to obtain information on employees' activities and
whereabouts. Businesses keep tabs on employees in order to boost efficiency and safeguard
company assets.

• Monitor Working Days and Holidays: This is the practice of employers watching over their
employees' activities in the workplace and working days in order to ensure that they are
productive. It will also help them to be aware when should their customer be active or take a
break.

• Set Leave Processing: Employee leave request, approval, and monitoring will be aided by
leave management in an organization's administrative processes and controls. With the help
of this module, this task would be much lighter and manageable for the admin. • Generate
Leave Reports: It's useful for keeping track and securing the leave information of the
employees. This can also can assist in problem solving and avoid conflicts. Generating these
reports will assist the admin in updating details regarding important information.

Advantages And Limitation

Advantages of leave management system:-

1) Ease of Use
2) Authorization to Leave
3) Transparency
4) Accurate and Precise Information
5) Leave policy Awareness
6) Implement Disciplines
7) No Manual Data Entry Errors

25
 8) Saving Time and Mental Bandwidth of HR managers
9) Collaborative Leave Planning
10) Leave Analytics

Limitation of a Leave Management System:-

1) Security Risk
2) Cost
3) Staffing
4) Scalability

Conclusion

This system is effective in reducing manual errors and provides ease

to the user. The paperwork is avoided. Manual labour as well as time
is saved. This system is also cost effective and easy and easy to install
and implement. The data is safe in the database and hence, data loss is
avoided Thus, the system is efficient and user interactive.

26
s

Future enhancement

The GUI of the system can be made more interactive using

latest technologies.
The admin could be able to search employee details using the
search bar instead of going to the employee management module.
The system can be designed for android also.
The provision can be designed to replace the employee on leave
with the other employee depending on the convenience.

27
 Bibliography

1) www.google.com
2) www.w3schools.com
3) www.stackoverflow.com
4) www.youtube.com

28
.

29